You're welcome!

--
Biff
Microsoft Excel MVP


"Chris" wrote in message
...
On Oct 31, 1:14 pm, "T. Valko" wrote:
If I understand....

=TEXT(DATE(2008,MONTH(NOW())-A1,1),"mmmm")

Copy down as needed

Based on your data these are the results:

11 = November
2 = August
0 = October
7 = Match
4 = June

--
Biff
Microsoft Excel MVP

"Chris" wrote in message

...



Hi all,

Had a question about creating a formula. The following is an example
of the data I have:

Month of last status MonthsSinceUpdate

11
2
0
7
7
0
0
4
4

I have a formula to calculate how many months since the last update,
but is there a way I can create a formula so it can automatically
determine what month that is based on the current month? Any
suggestions?

Thanks,
Chris- Hide quoted text -

- Show quoted text -

Thanks for the help! Got it to work!

-Chris