number or working days
it is exactly what i was looking for but
it seems to calculate a day less
Then that means it *isn't* exactly what you were looking for ! <g
I see in your other post that you want to avoid using the NETWORKDAYS
function.
If the formula is consistently off by 1 day then just add 1 to the result.
What about holidays? Do you need to exclude any holidays?
This formula will count the weekdays Monday through Friday between 2 dates
(inclusive):
=SUM(INT((WEEKDAY(B16-{1,2,3,4,5},2)+C16-B16)/7))
--
Biff
Microsoft Excel MVP
"Gibbyky2" wrote in message
...
Jacob kindly gave me the following formula for working out number of
working
days between 2 dates. it is exactly what i was looking for but it seems to
calculate a day less
formula
=(C16-WEEKDAY(C16,2)+WEEKDAY(B16,2)-B16)/7*5-MIN(5,WEEKDAY(B16,2))+MIN(5,WEEKDAY(C16,2))
where c16 is 17th july 2009 and B16 is 13th july 2009
the formula works out 4 days but it should be 5 days
i am also looking to calculate the number of days (in this case 5) by 7.4
many thanks
|