difference between dates excluding weekends

[isma786]

Hi

I would like to find the number of days between two dates that does not count weekends (Sat,Sun).

thanks for your time

 

[xlbo]

Have a look at the NETWORKDAYS function - it's part of the analysis toolpak (Tools>AddinsAnalysis Toolpak)

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[isma786]

Is there anyway of excluding bank holidays automatically as well without having to list the dates to exclude like networkdays offers?

 

[xlbo]

nope - think about it - bank holidays are A: Entirely optional for employers and B: different in every country

That's why there is an OPTION to include them if you wish, as a range of dates

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[isma786]

Thanks Geoff

 

[Bowers74]

P.S. Have a look at my FAQ:

faq68-4037 - What are some of Excel's date functions?



Peace!!

Mike

Didn't get the answers that you wanted? Then . . . Click Here