Excel Pop-up Calendar for Date Duration Calculation
Budget: $15 – $25 AUD
I need an Excel expert to integrate a pop-up calendar in my spreadsheet for calculating durations.
Key Requirements:
- Develop a pop-up calendar: The main task involves creating a pop-up calendar that allows users to input multiple dates. The calendar will then calculate the duration between those dates in months.
- Handle overlapping dates: The spreadsheet should be designed to automatically ignore overlapping months. For instance, if two given date ranges have overlapping months, the calendar should only count each month once.
Timeframe:
I'm looking to get this project completed ASAP. Please ensure you can commit to this timeline before bidding.
Ideal Skills and Experience:
- Proficiency in Excel and VBA programming.
- Prior experience in creating pop-up calendars.
- Strong understanding of how to manage date calculations and overlapping periods in Excel.
The above is AI generated explanation - below is mine i have written
I'm looking for someone to put some coding into my excel spreadsheet. I have clients who are builders who need to list 3-7 years of building experience. We have a basic spreadsheet where they list their projects and the dates they started and finished the project. We need to make it as basic as possible so they simply list the start and finish date - ideally picking from a pop up calendar. Then we need to spreadsheet to add up the months but remove any overlapping months. We some other basic rules to be added but they are simple additions. If you could make it look a little more professional that would be great. I have attached the current version - note the 2 x sheets. Sheet is what the client sees - Sheet 1 is a manual system that we use so we can see which months are missing. Ideally the client fills in sheet 2 and sheet 1 is updated automatically - so they boxes mark months that is covered with an "X" or whatever is easier
Key Requirements:
- Develop a pop-up calendar: The main task involves creating a pop-up calendar that allows users to input multiple dates. The calendar will then calculate the duration between those dates in months.
- Handle overlapping dates: The spreadsheet should be designed to automatically ignore overlapping months. For instance, if two given date ranges have overlapping months, the calendar should only count each month once.
Timeframe:
I'm looking to get this project completed ASAP. Please ensure you can commit to this timeline before bidding.
Ideal Skills and Experience:
- Proficiency in Excel and VBA programming.
- Prior experience in creating pop-up calendars.
- Strong understanding of how to manage date calculations and overlapping periods in Excel.
The above is AI generated explanation - below is mine i have written
I'm looking for someone to put some coding into my excel spreadsheet. I have clients who are builders who need to list 3-7 years of building experience. We have a basic spreadsheet where they list their projects and the dates they started and finished the project. We need to make it as basic as possible so they simply list the start and finish date - ideally picking from a pop up calendar. Then we need to spreadsheet to add up the months but remove any overlapping months. We some other basic rules to be added but they are simple additions. If you could make it look a little more professional that would be great. I have attached the current version - note the 2 x sheets. Sheet is what the client sees - Sheet 1 is a manual system that we use so we can see which months are missing. Ideally the client fills in sheet 2 and sheet 1 is updated automatically - so they boxes mark months that is covered with an "X" or whatever is easier