EXCEL - need help with IF for dates on schedule
 

I have been trying to get a schedule to accept IF values to exclude sundays
and add one day. Example IF __ = Sunday then add 1 or if __=holiday then
add 1

This is a construction schedule which requires X amount of days between each
activity

Suppose you have a date in A1
In A2 enter =IF(WEEKDAY(A1)=1,A1+1,A1)
Format both A1 and A2 as Date.
So if the date in A1 is a Sunday A2 will have the next day.
--
Gary''s Student


"Spear" wrote:

I have been trying to get a schedule to accept IF values to exclude sundays
and add one day. Example IF __ = Sunday then add 1 or if __=holiday then
add 1

This is a construction schedule which requires X amount of days between each
activity