Working days between 2 dates

E

Excel Dubai

Hello,

I am trying to count the number of working days between the start and the
end of a parcel delivery report. The only problem is that the concerned
operations are running from Monday to Saturday included. There is a basic
function in Excel with networkdays(start, end) but it considers saturdays and
sundays as week end. Any idea in order to only have sunday as week end. Your
help will be highly appreciated.
 
J

John

Hi
If You want 6 day week you can add +1 at the end of your formula.
ex. =NETWORKDAYS(Monday,Sunday)+1 will give you 6.
HTH
John
 
S

Shane Devenshire

Hi,

Try this

=ROWS(INDIRECT(A1&":"&A2))-SUMPRODUCT(--(MOD(ROW(INDIRECT(A1&":"&A2)),7)=1))

Where the start date is in A1 and the end date in A2
 

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

Amazon are rubbish 14
Count items based on two criteria 7
count work days excluding Fridays and Saturdays ??? 3
NETWORKDAYS function 1
Working Days excluding Sundays 6
Counting Days of Week 2
Networkdays including Saturday? 5
how to change week-offs from saturday and sundays to sunday and mo 2

Top