| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can i determine number of weeks between 2 dates
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how can i determine number of weeks between 2 dates
=INT((A2-A1)/7)
Where A2 is the later date -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "amanda" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating number of weeks between two dates | Excel Worksheet Functions | |||
| Calculating number of weeks between dates? | Excel Worksheet Functions | |||
| calculating number of weeks between two set dates | Excel Worksheet Functions | |||
| Calculating number of weeks from two dates | Excel Discussion (Misc queries) | |||
| HOW TO CALCULATE NUMBER OF WEEKS BETWEEN TWO GIVEN DATES(MAY BE . | Excel Worksheet Functions | |||
Linear Mode
