Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
In my excel file, I have to add a certain number of days to any given date.
If the end date ends up on a weekend, I need to round it up to the next week day. For example. The contractor timing is 20 calendar days (Not business days). The start date may vary, but the Contractor timing is set at 20 days. What date formula do I use to calc calendars days but not end up an a weekend. Column A Column B Column C Start Date Timing Due Date 11-30-09 20 days 12-20-09 (needs to be Monday 12-21-09) This is what I was using, but it's seems there must be a easier way. =IF(WEEKDAY($a2+$B2)=7,($a2+$b2)+2,IF(WEEKDAY($a2+ $b2)=1,($a2+$b2)+1)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting calendar days | Excel Worksheet Functions | |||
Is there a formular for calendar days | Excel Discussion (Misc queries) | |||
aging days between dates | Excel Discussion (Misc queries) | |||
Calendar days | Excel Worksheet Functions | |||
Calendar day not days | New Users to Excel |