![]() ![]() This function is an alternative to the VB/VBA function DateDiff, which does not measure full months or full years, and to the not-well-known Excel function DATEDIF, which usually works well, but can give unexpected results near a month end. ![]() This function returns a string with the elapsed time between two dates in such terms. This is most often the case with ages, especially in terms of records for the youngest or oldest person to have accomplished a particular feat. Sometimes, people like to express the elapsed time between two dates interms of full years, months, and days. This function may be used in any VBA or VB project (as well as Excel worksheet formulas or Access forms, queries, and reports) to return an "aging" string of full years, months, and days elapsed between two dates ![]() Function to return whole years, months, and days between two dates ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |