Formula with current Date
 

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- :)


--
alfiboy
------------------------------------------------------------------------
alfiboy's Profile: http://www.excelforum.com/member.php...o&userid=21730
View this thread: http://www.excelforum.com/showthread...hreadid=448759

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- :)

=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- :)

You guys rock!! thanks a lot :)


--
alfiboy
------------------------------------------------------------------------
alfiboy's Profile: http://www.excelforum.com/member.php...o&userid=21730
View this thread: http://www.excelforum.com/showthread...hreadid=448759