Can Excel Handle Dates Before 1900 (Yes!) | Difference in Years, Month or Days
👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted...
Thank you! 👍👍
Download the featured file here: https://www.bluepecantraining.com/wp-...
In this video I demonstrate how to perform calculations on dates before 1900. As you may know Excel does not recognise dates before the 01/01/1900. However if you add 1000 years to a pre 1900 date you will get a date that Excel does recognise.
Table of Contents:
00:00 Introduction
00:28 Add a 1000 years to a recognised date using EDATE
01:01 Add a 1000 years to a pre 1900 date
03:06 Calculate difference in days between two dates
05:22 Calculate difference in years between two dates
06:31 Calculate difference in months between two dates
*************************************
------------------------