Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
returning a date 7 business day excluding holidays in the future | Excel Worksheet Functions | |||
Calculate a future date, not including Sat/Sun or Bank Holidays | Excel Discussion (Misc queries) | |||
excel total days formula including weekends, excluding holidays | Excel Discussion (Misc queries) | |||
EXCEL 2003 7 Day Week plus Holidays | Excel Discussion (Misc queries) | |||
Project future date w/ 6 day work week and holiday | Excel Discussion (Misc queries) |