JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,535
- Office Version
- 365
- Platform
- Windows
Is there a UDF that will calculate the number of days between two dates even if one or both are before 1/1/1900?
On this page,
M$FT provides a "macro" (AgeFunc) that it says solves the problem. I don't know what idiot wrote this, but it's **** near worthless. The biggest problem is that it returns the number of years, not days, so it's not compatible with everything M$FT does with dates. Then, instead of returning a floating point number, it rounds down. So two dates that are 364 days apart are reported as 0 years. Idiots.
Why the h*ll doesn't M$FT finally support dates before 1/1/1900 by simply using negative numbers.
On this page,
How to calculate ages before 1/1/1900 in Excel - Microsoft 365 Apps
Describes how to use Macro to calculate age before 1/1/1900 in Excel.
docs.microsoft.com
M$FT provides a "macro" (AgeFunc) that it says solves the problem. I don't know what idiot wrote this, but it's **** near worthless. The biggest problem is that it returns the number of years, not days, so it's not compatible with everything M$FT does with dates. Then, instead of returning a floating point number, it rounds down. So two dates that are 364 days apart are reported as 0 years. Idiots.
Why the h*ll doesn't M$FT finally support dates before 1/1/1900 by simply using negative numbers.