EXCEL - need help with IF for dates on schedule

S

Spear

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
 
G

Gary''s Student

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.
 
Top