Forum Discussion
calculate date difference
I am looking for a formula to calculate the difference between two dates, while controlling for the year. I have a series of pairs of dates (A1,B1) (A2,B2)... The first date always precedes, or is ...
Riny_van_Eekelen
This is VERY helpful. However, I don't quite understand why there is a +1 at then end of the formula. Could you possibly explain it to me?
This is VERY helpful. However, I don't quite understand why there is a +1 at then end of the formula. Could you possibly explain it to me?
rreiser68 Think of it this way. How many days are there between January 1 and January 31? Without the +1, the formula just subtracts the (numeric) value for the start date from the value for the end date and returns 30. With the +1, the result equals 31.