6 day work week

D

daddylonglegs

More clarification required, do you want to calculate working days between
two dates based on a 6 day work week, or project a future date based on
number of working days added, or something else? Do you want to take holidays
into account?
 
T

tkirchoff15

Thanks
I need both
1. calculate working days between two dates based on a 6 day work week
2. project a future date based on 6 working days..no Holidays

Thanks for your help
 
T

Teethless mama

Let's say 6 day work week (Mon-Sat)
Assuming A1 is your start date
A2 is your end date

A3 =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))={2,3,4,5,6,7}))
 
T

T. Valko

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))={2,3,4,5,6,7}))

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))>1))

=SUM(INT((WEEKDAY(A1-{1,2,3,4,5,6},2)+A2-A1)/7))

Biff
 
Top