including current date in formula

C

Candace

I need to include the current month (such as 1, 2 3, ... etc for the number
of the month) in a formula. What I am doing is taking a total amount and
dividing that by the number of the current month (such as 2 for February) and
then multiplying that by 12. For example

D12 / (month of the year) * 12

But I need to replace "month of the year" with something that actually works
in a formula. Any help would be appreciated. Thanks.
 
B

Bernard Liengme

Current month is found with =MONTH(TODAY())
So your formula could be =D12*12/MONTH(TODAY())
best wishes
 
J

joeu2004

Candace said:
I need to include the current month (such as 1, 2 3, ... etc
for the number of the month) in a formula. [....] For example
D12 / (month of the year) * 12
But I need to replace "month of the year" with something
that actually works in a formula.
Click to expand...

I think the following does what you asked literally:

=D12 / MONTH(NOW()) * 12

But I wonder if that is what you really meant to ask or
should have asked. You wrote ....
What I am doing is taking a total amount and dividing that
by the number of the current month
Click to expand...

Do you really want the number 3 (March) if the total reflects
only the numbers through February (2), but you are looking
at the worksheet in March?

I suspect what you want is MONTH(A11), where A11 contains
the date of the last entry included in the total.
 
Top