WORK OUT NUMBER OF WEEKS BETWEEN TWO DATES

[Guest]

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]

One way:

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