WORK OUT NUMBER OF WEEKS BETWEEN TWO DATES

cyp010905 · Mar 7, 2006

I want to creat a formula that will work out the number of weeks between two
dates but i can only find formulas for days or months . can anyone help

JE McGimpsey · Mar 7, 2006

One way:

A1: <start date>
A2: <end date>
A3: =(A2 - A1)/7