Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to set up a date schedule but am not sure of the best way to
incorporate holidays. For example, my start date is 12/25/05. I need to add a formula that takes 12/25/05 plus 90 days but if that date falls on a Saturday or Sunday, the returned date needs to be Monday. The end result would be 3/27/06. But, I also need to say that if the end date (3/27/06 in my example) falls on a holiday, I need to go to the next date but again if that date falls on a Saturday, need to go to Monday. I hope this makes sense. Any suggestions would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting (Dates) Repost with additional data | Excel Discussion (Misc queries) | |||
PivotTables - Group Dates, excluding dates | Excel Discussion (Misc queries) | |||
Counting dates for a the present month but not future months | Excel Worksheet Functions | |||
Finding dates within a date range | Excel Worksheet Functions | |||
formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) |