| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
HOW TO CALCULATE NUMBER OF WEEKS BETWEEN TWO GIVEN DATES(MAY BE .
What is the formula for calculating the number of weeks between two given
dates which may be in different years eg 10.01.2002 and 14.05.2004 |
|
#2
|
|||
|
|||
|
Hi
=INT((Date2-Date1)/7) gives the number of full weeks =MOD(Date2-Date1,7) gives number of remaining days -- When sending mail, use address arvil<attarkon.ee Arvi Laanemets "WARRENCHERYL" wrote in message ... What is the formula for calculating the number of weeks between two given dates which may be in different years eg 10.01.2002 and 14.05.2004 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I increment a date by a certain number of weeks? | Excel Worksheet Functions | |||
| calculate weeks from a start date ( not yr weeks) | Excel Worksheet Functions | |||
| calculate month from week number | Excel Worksheet Functions | |||
| How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions | |||
| Need number of months or weeks passed from formula | Excel Worksheet Functions | |||
Linear Mode
