Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
including current date in formula
If you have 2/1/2006 (February 1) in cell A1, the following will return "2":
=MONTH(A1) ************ Hope it helps! Anne Troy www.OfficeArticles.com Check out the NEWsgroup stats! Check out: www.ExcelUserConference.com "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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
including current date in formula
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula for filtering and a defaulting date | Excel Worksheet Functions | |||
imported impromtu report date issue - fix by format or formula | Excel Discussion (Misc queries) | |||
formula IF returning current date | Excel Worksheet Functions | |||
Expired Date Formula | Excel Worksheet Functions | |||
Date formula | Excel Discussion (Misc queries) |