Microsoft Office Tutorials and References
In Depth Information
Use custom functions
➤ XDATEYEAR(xdate1): Returns the year of a date.
➤ XDATEMONTH(xdate1): Returns the month of a date.
➤ XDATEDAY(xdate1): Returns the day of a date.
➤ XDATEDOW(xdate1): Returns the day of the week of a date (as an integer between 1 and 7).
Figure 39-3 shows a worksheet that uses some of these custom functions.
Figure 39-3: Using custom functions to work with pre-1900 dates.
The extended date functions don’t make any adjustments for changes made to the
calendar in 1582. Consequently, working with dates prior to October 15, 1582, may not
yield correct results.