These pages are no longer updated and are only available for archive purposes.
Click here to visit the pages with updated information.
Calculate with dates
The TODAY()-function returns a serial number for the current date, as long as the computer date and time is set correctly. The serial number is a long integer counting the number of days since 1. january 1900 (serialnumber=1). The cell containing the function must be formatted to display numbers as dates.
Excel calculates dates including leap years.
If you enter two dates in two different cells, you can perform a calculation with the
You can enter a date in a cell by using the following separator signs between days,
months and years :
Document last updated 2000-04-14 12:44:38 Printerfriendly version