View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Candace
 
Posts: n/a
Default including current date in formula

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.