View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] Smythe32@aol.com[_2_] is offline
external usenet poster
 
Posts: 6
Default Calculating a Due Date that is not a holiday or weekend

All,

Looking for some assistance here. I need to take a date, add a number
of CALENDAR days and then ensure that the new date is not a holiday or
weekend. I cannot use workdays because it adds just workdays and I
need to add calendar days.

Ex: Start Date 12/22/06 add 10 calendar days. Holidays 12/25/06,
1/1/07. Ending date should be:
01/02/07.

Any help would be greatly appreciated.

Thanks