including current date in formula
"Candace" wrote:
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.
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
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.
|