ExcelBanter - WORK OUT NUMBER OF WEEKS BETWEEN TWO DATES

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - WORK OUT NUMBER OF WEEKS BETWEEN TWO DATES (https://www.excelbanter.com/excel-worksheet-functions/75744-work-out-number-weeks-between-two-dates.html)

cyp010905

WORK OUT NUMBER OF WEEKS BETWEEN TWO DATES

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

WORK OUT NUMBER OF WEEKS BETWEEN TWO DATES

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

All times are GMT +1. The time now is 12:31 PM.