Assign values to find Current Month in a Range

[sharann via OfficeKB.com]

I am working on a 30,60,90 days report in excel that provides a sales rep
with a Projected Close Date.
I need to figure out how to make the most current month equal 30 the second
month equal 60 and the third month equal 90.

For example this report I need a formula that sees "April" as the current
month and assign it to 30, "May" as second month and assign it to 60 and so
on.

Projected Close Date
A1="April"
A2="May"
A3="June"

Please note that the Projected Close Date will change next month. For
example next month it will be May, June, July.

Any help is greatly appreciated!

 

[Bob Phillips]

Perhaps

=(MONTH(A2)-(MONTH(TODAY())-4))*30

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)