Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hey sorry to bother you guys again, but I've got a slightly different problem
now. I used T. Valko's formula =TEXT(EDATE(B5,6),"mmmm") which works great. This formula is in cell A6. In my example, the value in cell B5 is 02/15/10. T. Valko's formula (in cell A6) returns the value "August", which is correct. Now, however, I need a formula for cell A7, which will look at the answer in A6 (e.g. August) and add 3 more months to that value, returning an answer of November. I've tried modifying the formula T. Valko gave me but obviously I'm doing something wrong because Excel keeps giving me an error message. Thanks again for any help you can offer guys! Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Follow Up Macro Question | Excel Discussion (Misc queries) | |||
Follow up Question to Countif | Excel Discussion (Misc queries) | |||
A follow up Question | Excel Discussion (Misc queries) | |||
Follow-up AVERAGEIF question | New Users to Excel | |||
Follow-Up (Clarification) to MIN question | Excel Discussion (Misc queries) |