About this document
Extended Date Functions for Excel by rkvance5 is a document available to read on EtoBox.
The Extended Date functions enable working with dates from years 0100 to 9999 in Excel, which normally only supports dates from 1900 onwards. The functions were developed by JWalk & Associates and are freely distributed. They include functions to add/subtract dates, calculate date differences in days or years, and extract the year, month, day, and day of week from dates. Users should be careful with dates prior to 1752 due to calendar changes, and always use 4-digit years to avoid errors.
- Author
- rkvance5
- Language
- EN