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 ...
the raw representation for dates is in days so basically just subtract the 2 dates. I don't understand the "while controlling the year" part.