< Day Day Up > |
Although dates appear as dates (August 11, 2005, for example) in your Calc sheets, these dates actually have numerical significance. For example, you might need to calculate the number of days between two different dates. You can actually subtract the earlier date from the later date and be provided the number of days that they differ. The date is actually seen by Calc as a numerical value; so when you enter 11/22/2005, you see it as a date, but Calc sees it as a number the number of days that have elapsed since January 1, 1900. So, Calc sees 11/22/2005 as 38,678. Enter Date
Open Format Cells Dialog
Format Date
|
< Day Day Up > |