15 Jul 2012
Use the shortcut CTRL + ; to enter the current date into a cell in Excel as a value. It will also indicate the format of the date on your system, i.e. dd/mm/yyyy or mm/dd/yyyy or yy/mm/dd.
To enter a date that will change to the current date, everytime file is opened, use the =Today() function
To build a date out of an existing date, use =Date(y,m,d). A good example is to build a date that will go to the end of the next month. if a value in cell A1 contains a date then: =date(year(A1),month(A1) +2, 1) - 1 (The trick is to go to the first day of two months from now and then subtract 1 day to get to the end of the next month)