Working with dates

Hello Lisa,

You can calculate working days by using the function:
=networkdays(start date, end date)

This function also allows for holidays to be included as a third attribute. Heres an example:

If you have 1/1/11 in cell A1, 20/2/11 in A2, and your holidays listed in cells B1:B3 e.g. 5/1/11, 13/1/11,19/1/11

=networkdays(A1,A2,B1:B3)

this gives you 32 days, working, no weekends or holidays.


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer