Date formulas

Charles · May 19, 2004

I want to be able to calculate the number of whole weeks between 2 given dates so that the third cell will show that amount

Norman Harker · May 19, 2004

Hi Charles!

Try:
=INT((B1-A1)/7)

David McRitchie · May 19, 2004

If that is not what you want describe what you mean by a whole
week. ie. full Sun - Sat weeks or other range.