Number of Weeks between two dates

  • Thread starter Thread starter ibeetb
  • Start date Start date
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?
 
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?
 
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?
 
Back
Top