Microsoft Office Tutorials and References
In Depth Information
Using DATE to Calculate a Date from Year, Month, and Day
=DAY(date) returns the day of the month, from 1 through 31.
=HOUR(date) returns the hour, from 0 to 23.
=MINUTE(date) returns the minute, from 0 to 59.
=SECOND(date) returns the second, from 0 to 59.
Figure 11.38.
Figure 11.38. These six functions allow you to isolate any portion of a date
These six functions allow you to isolate any portion of a date
or time.
or time.
In each case, datemust contain a valid Excel serial number for a date. The
cell containing the date serial number may be formatted as a date or as a
number.
Using
Using DATE
DATE to Calculate a Date from Year, Month, and Day
to Calculate a Date from Year, Month, and Day
The DATE function is one of the most amazing functions in Excel. Mi-
crosoft s implementation of this function is excellent, allowing you to do
amazing date calculations.
Search JabSto ::




Custom Search