Current month is found with =MONTH(TODAY())
So your formula could be =D12*12/MONTH(TODAY())
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Candace" wrote in message
...
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.