LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 19
Default Follow up on date function question

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Follow Up Macro Question MrAcquire Excel Discussion (Misc queries) 4 February 12th 10 04:55 PM
Follow up Question to Countif Ajay Excel Discussion (Misc queries) 4 February 16th 09 06:22 PM
A follow up Question Andrew Mackenzie Excel Discussion (Misc queries) 4 November 17th 08 02:50 PM
Follow-up AVERAGEIF question Ken[_3_] New Users to Excel 2 April 11th 08 05:45 PM
Follow-Up (Clarification) to MIN question Odawg Excel Discussion (Misc queries) 4 October 20th 05 04:04 AM


All times are GMT +1. The time now is 06:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"