Formula to calculate month of last status update

[Chris]

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

 

[Spiky]

Sounds like a perfect solution for EDATE. If you have the Analysis
Toolpack installed, or Excel 2007.

 

[ShaneDevenshire]

Hi,

=MONTH(EDATE(TODAY(),-C1))

Where C1 contains your numbers below. EDATE is an analysis toolpak function
so you must attach it - Tools, Add-ins, and check Analysis ToolPak

 

[T. Valko]

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

 

[Chris]

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









- Show quoted text -

Thanks for the help! Got it to work!

-Chris

 

[Spiky]

Hi,

=MONTH(EDATE(TODAY(),-C1))

Don't think you want the MONTH function. Just format the cell as
"mmmm".

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

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









- Show quoted text -

Thanks for the help! Got it to work!

-Chris