View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default 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.