multiply by current months number

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

Hi. I need a formula that can figure the number of the
current month and multiply by it.

=F9/12*MONTH(A1) is the formula I am using now. A1
contains the Today() function. But, Can I figure the
number of the current month and *f9 by it in a single
formula?


TIA

Todd
 
Todd

you could use: =MONTH(TODAY())

Hence: =F9/12*MONTH(TODAY())

Regards

Trevor
 
Just replace A1 by TODAY()

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top