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. |
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) |