multiply by current months number

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
 
T

Trevor Shuttleworth

Todd

you could use: =MONTH(TODAY())

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

Regards

Trevor
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Percentage of month passed formula 1
find out specific month and year 1
YTD SUMIF based on current date 3
Is there any programming tool which can calculate single worksheet 3
Expanding Date Formula 0
Rolling 12 month 9
Excel - Wich Function should I use? 1
Mapping strings to integers 6

Top