Calendar Functionality

Good afternoon

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?

Thanks

Graeme

Thanks Macdave. Much appreciated.

I was trying to see how you did it on your example but for some reason when i enter design mode it doesn't let me check the coding. I am probably doing something wrong but if you can suggest something that would be great!

Thanks

Graeme