Forum Discussion
Guido_Abbat1505
Apr 06, 2021Copper Contributor
Excel: calculate dates difference
Dear All, I have this problem with my Excel being part of Office 2019 Professional Plus. When using the formula for calculating difference in days between dates (in the Italian version the formula i...
bhcStuart
Apr 06, 2021Copper Contributor
Guido_Abbat1505 Excel dates are held as integers with 1 being 01/01/1900 using dates before this in excel is tricky and not native to excel. Could you offset all your date with the same value to bring them after 01/01/1900, i.e add 2000 years to each date, this would then allow you to use the datedif function.