TheRealTMA
Senior Member
- Joined
- Jul 13, 2012
- Posts
- 7,895
- Qantas
- Platinum
Maybe this would be useful?I guess they can't change their definition of 'date' now, but you'd think they could add one more date function tool to accommodate <1900.
How to calculate ages before January 1, 1900 in Excel - Microsoft 365 Apps
Describes how to use Macro to calculate age before January 1, 1900 in Excel.
learn.microsoft.com
Or store the <1900 date as text and use a string function to do calculations.
Another example. Deal With Dates Before 1900