Microsoft Office Tutorials and References
In Depth Information
Use custom functions
Unfortunately, you can’t perform other date-related operations for these pre-1900 dates. For
example, you cannot perform subtraction to determine ages.
Figure 39-2: The presidents sorted by birthday, after performing three sorts.
Use custom functions
I created an Excel add-in, XDATE, which contains a number of functions written in VBA. These
functions enable you to work with dates in the years 0100 through 9999. You can download a free copy
from my website: http://spreadsheetpage.com .
The extended date functions are
XDATE(y,m,d,fmt): Returns a date for a given year, month, and day. As an option, you can
provide a date formatting string.
XDATEADD(xdate1,days,fmt): Adds a specified number of days to a date. As an option, you
can provide a date formatting string.
XDATEDIF(xdate1,xdate2): Returns the number of days between two dates.
XDATEYEARDIF(xdate1,xdate2): Returns the number of full years between two dates (use-
ful for calculating ages).
Search JabSto ::




Custom Search