I am hoping someone can help me!
I am trying to use Design control in Excel 2007 to create a spreadsheet which allows people to look at a calendar in the document, click on a date and that date is entered into the cell. Similar to when you do online when you, say, go to book a flight and you can select the date on the calendar.
The document we are trying to create is for annual leave where people put their start and finish dates and it automatically calculates the number of days between. At the moment, people have to put the date in a formula format (eg =DATE(YYYY,MM,DD) rather than just typing in a date or else it won't calculate it for you!
Can anyone help with suggestions?