One way:

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

In article ,
cyp010905 wrote:

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