| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Microsoft Excel in Microsoft works - how to open | Excel Discussion (Misc queries) | |||
| Creating Machine shop part schedule using Excel | Excel Discussion (Misc queries) | |||
| Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
| How do I create project schedule using excel - office 2000 | Excel Discussion (Misc queries) | |||
Hybrid Mode
