How to calculation no. of days (only working days) between two dat

G

Guest

I have two date in date format, when I minus the two I can get the no. of
days. Any solution to exclude sat and sun, so only working days is counted?
 
G

Guest

Hi,

Check out networkdays

=NETWORKDAYS(A1,B1)

Where A1 is the earlier date. The formula can also take a 3rd argument for
holidays so look at help.

Mike
 

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

Calculating difference between dates 3
DAYS BETWEEN DATES 19
Display the days between start & end date columns 3
Calculating Working Hours, Days and Overtimes. 1
Determine weekday counts 3
How to calculate the number of days between two dates 2
Counting Days of Week 2
Counting number of days excluding certain values 3

Top