Formula to calculate month of last status update
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
|