Number of Weeks between two dates

I

ibeetb

Excel seems to have a function toi cal the number of days and number of
months, bit not number of weeks

How would I calculate the # weeks between 2 dates?
 
D

Dean

I have not tried it yet, but could you calculate the
number of days first...the either divide that by 7 or mod
that by 7?
 
H

Harlan Grove

Excel seems to have a function toi cal the number of days and number of
months, bit not number of weeks

How would I calculate the # weeks between 2 dates?
Click to expand...

Either INT((EndDate-StartDate)/7) or if you have the Analysis ToolPak loaded
you may prefer WEEKNUM(EndDate)-WEEKNUM(StartDate). This still leaves
specification details such as how many weeks would you want for the number of
weeks between 23-Sep-2003 and 27-Sep-2003?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function to calculate the nuber of weeks between dates? 4
Create Calculation to return number of weeks and days 6
Calculating number of weeks between dates? 2
Formula to calculate the difference in weeks between two dates 3
Date Diff - excluding working days 2
calculating number of weeks between two set dates 2
WORK OUT NUMBER OF WEEKS BETWEEN TWO DATES 1
calculating number of weeks between two dates 4

Top