Removing Saturday and Sunday from five day intervals

Mar 1st, 2002, 12:38 PM

Help.

I am tasked with calculating five working day intervals for start and end times, not including weekends.

The start date may be a Monday, with the job due on a Friday - easy - five days total.

The problem is when I get a start day on a Tuesday and then the finish day on the next Monday (the weekend days are included even though they don't really count as working days) the total days works out to seven (when in actual fact, the duration is five working days).

How can I set this up so that the weekend days are omitted in my query?

Ian Mac · Mar 1st, 2002, 12:51 PM

Try

=NETWORKDAYS(A1,A2)

where A1 = Start day
and A2 = End day

Inclusive

Ian Mac

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 1st, 2002, 12:38 PM	#1
Guest Posts: n/a	Help. I am tasked with calculating five working day intervals for start and end times, not including weekends. The start date may be a Monday, with the job due on a Friday - easy - five days total. The problem is when I get a start day on a Tuesday and then the finish day on the next Monday (the weekend days are included even though they don't really count as working days) the total days works out to seven (when in actual fact, the duration is five working days). How can I set this up so that the weekend days are omitted in my query?

Mar 1st, 2002, 12:51 PM	#2
Ian Mac MrExcel MVP Join Date: Feb 2002 Location: Newcastle, UK Posts: 1,174	Try =NETWORKDAYS(A1,A2) where A1 = Start day and A2 = End day Inclusive Ian Mac