A
ajitexcel
can anyone help me with this
a. how to get future date (like WORKDAY Function) but the formul
should include saturdays as work day excluding sundays and holidays.
for example if 2 mar 10 is the starting date then plus 15 day
including 2 holidays (say 5 mar 10 & 9 mar 10) and sundays (i.e. 7 ma
& 14 mar) the to be arrived should be 20 mar 10.
and the formula should also check if the date arrived is a saturda
then it should add following sunday i.e in above case it should becom
21 mar 10
:
a. how to get future date (like WORKDAY Function) but the formul
should include saturdays as work day excluding sundays and holidays.
for example if 2 mar 10 is the starting date then plus 15 day
including 2 holidays (say 5 mar 10 & 9 mar 10) and sundays (i.e. 7 ma
& 14 mar) the to be arrived should be 20 mar 10.
and the formula should also check if the date arrived is a saturda
then it should add following sunday i.e in above case it should becom
21 mar 10
: