Get Number of Date between two date but not include Saturday/Sunday

M

moonhkt

Hi All

How to using formula to "Number of Date between two date but not
include Saturday/Sunday" ?

e.g.
2010/12/03 to 2010/12/07 return 3 days.
2010/12/04 to 2010/12/07 return 2 days.

moonhkt
 
P

Pete_UK

Check out the NETWORKDAYS function in Excel Help. If you are using
Excel 2003 or earlier you will need to instal the Analysis Toolpak.

Hope this helps.

Pete
 
Top