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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Suming Up Time over the course of days 1
Formula to fill cells based on Date of Arrival and Date of Departure 1
week numbers 7
Check if a date comes before/after a range of dates 0
Calculating Overlaps 3
Return a value when Date x is between Date y and z 1
How to count non blank cells with a condition? 1
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0

Top