| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date in middle of month
Morning,
Scenario. Have got an opening date say the 2006-10-01 now I want another date - closing date the 2006-10-15 but if this closing date falls into a weekend then I want the next working day to be shown. The closing date must always be around the 15th of the month, but not on weekends (if so it can then be on the Monday or preceeding Friday) as mentioned above. My formula for closing date is currently =EOMONTH(C6,0) with is showing 2006-10-31, how can I modify this to meet my requirement mentioned above. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pick up date, month and year from a date | Excel Discussion (Misc queries) | |||
| Matching month part of date only | Excel Discussion (Misc queries) | |||
| Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
| GETTING MONTH FROM A DATE | Excel Discussion (Misc queries) | |||
| HELP with this function | Excel Worksheet Functions | |||
Threaded Mode
