EXCEL - need help with IF for dates on schedule

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Future date with six day week including holidays 1
count scheduled staff between hours 1
Does date in Cell A1 occur between the date in M1 and Date in X1 1
Adding up total hours worked on employee schedule using various criteria 0
count how many staff are scheduled between... 3
Calculating Turn Around Times excluding Sunday 1
How do I set up a calculation to exclude weekends? 6
Outlook 2007 and School class schedule 3

Back
Top