Add days to a specific date to get a later date.
 

hello all,
I have attached file for reference..Attachment 258698

I am trying to get a future date by adding n number of days with conditions like
There are three columns - departure(date entered by user), from(the problem cell), day(it shows day i.e monday, tuesday etc taken from departure column)
- if date in "depature" column happens to be saturday(day column) then "From" cell should have date of next monday. for example if departure date is 1 Jan and it is saturday then "from" column should have 3 Jan. if any other day then next day.
- but, if monday is holiday then "from" column should have 4 Jan and so on...

thanx
:confused:
Have posted it on http://www.excelforum.com/excel-form...ater-date.html