LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 5
Smile Future date with six day week including holidays

can anyone help me with this
a. how to get future date (like WORKDAY Function) but the formula should include saturdays as work day excluding sundays and holidays.

for example if 2 mar 10 is the starting date then plus 15 days including 2 holidays (say 5 mar 10 & 9 mar 10) and sundays (i.e. 7 mar & 14 mar) the to be arrived should be 20 mar 10.
and the formula should also check if the date arrived is a saturday then it should add following sunday i.e in above case it should become 21 mar 10
:)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
returning a date 7 business day excluding holidays in the future excelrookie Excel Worksheet Functions 2 February 25th 10 06:46 PM
Calculate a future date, not including Sat/Sun or Bank Holidays RR Excel Discussion (Misc queries) 2 May 26th 09 01:27 PM
excel total days formula including weekends, excluding holidays wtfisch Excel Discussion (Misc queries) 0 May 7th 08 04:53 PM
EXCEL 2003 7 Day Week plus Holidays GTFSSC Excel Discussion (Misc queries) 1 May 3rd 07 07:00 PM
Project future date w/ 6 day work week and holiday damucol Excel Discussion (Misc queries) 3 February 8th 07 02:41 PM


All times are GMT +1. The time now is 10:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"