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.

=networkdays(start date,end date,holidays)
--
paul
remove nospam for email addy!



"Mudgeman" wrote:

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.

Try using NETWORKDAYS(start_date, end_date, Holidays)