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!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200707/1

Perhaps

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

--
---
HTH

Bob

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



"sharann via OfficeKB.com" <u23578@uwe> wrote in message
news:74b8469f25878@uwe...
>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!
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...tions/200707/1
>