Method 2. (The simplest way)

Excel Pop-Up Calendar Add-in

Step 1: Download the (modified) Excel Add-In. Remember to save it somewhere memorable. I suggest you save it in a Folder called "Excel Pop-Up Calendar Add-in" saved (could be C:\Excel Pop-Up Calendar Add-in). so that u may not Delete that Folder in Future.

Step 2: Start up Excel Pop-Up Calendar Add-in.

Step 3: Go to Tools –> Add-Ins.

Step 4: Choose “Browse…”

Step 5: Locate the Calendar.xla file.

Step 6: Notice the Calendar Add-in has been…added..in..?

Step 7: Now whenever you need to enter a date into a cell (the Register again comes to mind), just right-click on the cell and select “Insert Date”.

Step 8: Notice that today’s date is selected by default. However, strangely enough “Her” was right. Friday was on the 9th… Once that date is selected it will automatically be entered into the cell.

Keep in mind that you still won’t be able to add dates to protected cells (and accidentally overwrite a crucial formula) unless you unprotect the sheet first.

Disclaimer: I have only tested this on my machine, which is running Windows XP, Excel 2003.

Link to Download the file:

http://www.ziddu.com/download/3177885/calendar.zip.html