Formula to find the working days difference between to dates?

M

Mudgeman

Is there a formula to work out the difference between 2 dates, but only the
working days difference. for example. if the 1st date was thursday 1st june,
and the 2nd date is monday 5th june, the days difference would be 4, where as
i would like the working days difference, which is 2. please help, as it
would save a LOT of time.
 
X

xlEnt

Mudgeman said:
Is there a formula to work out the difference between 2 dates, but only
the
working days difference. for example. if the 1st date was thursday 1st
june,
and the 2nd date is monday 5th june, the days difference would be 4,
where as
i would like the working days difference, which is 2. please help, as
it
would save a LOT of time.
Click to expand...
Try using NETWORKDAYS(start_date, end_date, Holidays)
 
Top