| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date plus month, year, or years in workdays
I've been trying to come up with a formula that will give me the date entered
(A2) plus the entry in B2, but also end up on a weekday. A2 = User entered date B2 = Data Validation List: 2 WK, 1 MO, 3 MO, 6 MO 1 YR, 2 YR, 3 YR, 4 YR Example, A2=Jul 18 2009 (Saturday); if "2 WK" is chosen, the date will should be Jul 31 2009 (Friday); if "1 YR" is chosen, the date should be Jul 16 2010 (Friday); etc., etc. Suzanne |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count month when date is in day/month/year format | Excel Worksheet Functions | |||
| Need to track last year to date information vs this years? | Excel Discussion (Misc queries) | |||
| Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
| if i save 25.00 a month for 40 years at 5% a year whats the total | Excel Discussion (Misc queries) | |||
| Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
Threaded Mode
