=MONTH(TODAY()) returns 9 for September.

So.........

=(F8/MONTH(TODAY())*12/E8)

Assuming the *8* is the the month in your formula.


Gord Dibben Excel MVP


On Tue, 6 Sep 2005 17:43:49 -0500, alfiboy
wrote:


Hello there,

I'm trying to create a formula in which the current month is part of
the formula but I wanted to be automatically when the month changes
instead of typing.

=(F8/*8*)*12/E8

How can the date be inserted automatically and still be part of the
fomula?

thanks for your help- :)