Working days between 2 dates

  • Thread starter Thread starter Excel Dubai
  • Start date Start date
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.
 
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
 
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
 
Back
Top