Dates are just serial numbers - the format determines the appearance of the # - eg Date/Number.
If you want to calculate based off dates it's simply a case of conducting standard arithmetic operations - 1 being 1 day, so:
will add one day to the date value in A1
It follows that Time is Decimal (1 = 24 hours) so:
would add 36 hours to the value in A1

Originally Posted by
L62H66
Here is something else that is odd. I put the following function into a cell:
=DATE(1,30,2011)
When I format the cell, I get the following:
3258 - general format
12/1/1908 - date format
That makes no sense whatsoever.
The Date function has three parameters: Year, Month & Day - in that order.
the 2011th date of the 30th month of year 1 is 12-Jan-1908.
is the 30th Jan 2011
You can of course equally enter: 1/30 as a constant.
Bookmarks