| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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  Have posted it on http://www.excelforum.com/excel-form...ater-date.html |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate the number of days from a specific date | Excel Discussion (Misc queries) | |||
| business day date from a specific date based on a number of days | Excel Worksheet Functions | |||
| How do I set up alarms based on days from a specific date? | Excel Worksheet Functions | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| countdown days,hours,minutes,seconds to a specific date | Excel Discussion (Misc queries) | |||
Threaded Mode
