WORK OUT NUMBER OF WEEKS BETWEEN TWO DATES

[cyp010905]

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

In article <E7507472-90B2-46E1-8BC5-9F482BF564F6@microsoft.com>,
cyp010905 <cyp010905@discussions.microsoft.com> 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