| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to calculate number of days between Dates | Excel Worksheet Functions | |||
| convert dates to number of days | Excel Worksheet Functions | |||
| Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
| How do you calculate number of workdays from dates entered? | Excel Worksheet Functions | |||
| HOW TO CALCULATE NUMBER OF WEEKS BETWEEN TWO GIVEN DATES(MAY BE . | Excel Worksheet Functions | |||
Linear Mode
