counting workdays

[mark gardner]

If I have a date in a1 and a later date in b1, how can I make c1 reflect the difference in days between them BUT not count weekends? ex: starting date is Friday...ending date is next tuesday for a total of 2 'working days'...is there a formula for this?

 

[Jonmo1]

Try the Networkdays function.
This is part of the analysis toolpack from tools - addins.
But if you're using XL2007 or higher, it's already included.

=NETWORKDAYS(A1,B1)

However, this is inclusive (it counts both start and end dates).

Depending on which day you want excluded, you can do this

To exclude the START date
=NETWORKDAYS(A1+1,B1)

To exclude the END date
=NETWORKDAYS(A1,B1-1)


Hope that helps.

 

[mark gardner]

perfect, thank you

 

[Jonmo1]

Glad to help.