One way:

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

In article ,
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- :)