View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mmanis mmanis is offline
external usenet poster
 
Posts: 5
Default aging calendar days

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))