Workdays including Saterdays

[DanWo]

I would like to calculate a End Date (B10 from a Start Date (A1) + Duration (C1) ; Duration in Working days (without WE & holidays) BUT including saterdays (this ids the problem!)

 

[Chattin]

Is this it?

=NETWORKDAYS(A1,B10)+SUM(IF(WEEKDAY(A1-1+ROW(INDIRECT("1:"&TRUNC(B10-A1)+1)))=C2,1,0))
A1 contains the beginning date of the interval
B10 contains the ending date of the interval
C2 contains the day-of-week number (1=Sunday, 2=Monday,...,7=Saturday)

 

[Chattin]

Just re-read your post and that wont do what you want! I'll have another look

 

[Chattin]

Ok then - try this

=A1+E1-NETWORKDAYS(1/1/2003,31/12/2003,holidays)+SUM(IF(WEEKDAY(A1-1+ROW(INDIRECT("1:"&TRUNC(B10-A1)+1)))=C2,1,0))

holidays - enter an array of your holidays for this year
E1= no. days to add

HTH

 

[DanWo]

if B10 is in the formula, it create a circular reference!

 

[DanWo]

There was error in my question ("0" instead of &quot"
Correction:
I would like to calculate a End Date (B1) from a Start Date (A1) + Duration (C1) ; Duration in Working days (without WE & holidays) BUT including saterdays (this is the problem!)