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

  • Thread starter Thread starter moonhkt
  • Start date Start date
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
 
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
 
Back
Top