This doesn't seem to work.

# of days 1
start date of 3/12/09 -Thursday

formula result is Friday 3/13/09


"Mike H" wrote:

Is this a different question?

=(A1+B1)+SUM(IF(WEEKDAY(B1-1+ROW(INDIRECT("1:"&TRUNC((B1+A1)-B1)+1)))=6,1,0))

This is an array formula which must be entered with CTRL+Shift+Enter and NOT
'just enter. If you do it correctly then Excel will put curly brackets around
'the formula{}. You can't type these yourself. If you Edit the ranges
'then you must re-enter as An array


Mike

"Naushad" wrote:

if in cell A1 is the no.of days and in cell B1 is the start date. How can I
have workday calculated in cell c1 with Friday as weekend and saturdays &
sundays as workdays.