View Full Version : Excel formula

06-05-2003, 03:25 PM
I need to determine the number of weeks between two dates. The end date is fixed and the number of days in a week is 5. The result I like to see is the number of weeks and days left over if any.
Can someone help please?

Iain Walmsley
06-05-2003, 03:52 PM
Assuming your dates are in Excel's number format, then the following formulas determines the number of days difference between the two days, and then return the number of 5 day blocks in this period, and the number of days left over.

5 day blocks "=TRUNC((<end date>-<start date>)/5,0)"
extra days "=(<end date>-<start date>)-(<number of weeks>*5)


Iain Walmsley
06-05-2003, 03:54 PM
Damn emoticons.

5 day blocks "=TRUNC{{<end date>-<start date>}/5,0}"
extra days "={<end date>-<start date>}-{<number of weeks>*5}

replace all the {} with rounded brackets in the formula.