| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically update month
In the formula below, I would like "X" to be the month's number, eg: Jan=1,
Feb=2, etc., but update automatically based on the current month. So if it is April, it would change to 4 on the first of April. Thanks for you help! =(6.67*X)-.04 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatically update month
=(6.67*month(today()))-0.04
Smilingmom wrote: In the formula below, I would like "X" to be the month's number, eg: Jan=1, Feb=2, etc., but update automatically based on the current month. So if it is April, it would change to 4 on the first of April. Thanks for you help! =(6.67*X)-.04 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatically update month
Thank you very much!
"Dave Peterson" wrote: =(6.67*month(today()))-0.04 Smilingmom wrote: In the formula below, I would like "X" to be the month's number, eg: Jan=1, Feb=2, etc., but update automatically based on the current month. So if it is April, it would change to 4 on the first of April. Thanks for you help! =(6.67*X)-.04 -- Dave Peterson . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update one worksheet tab to automatically update all other tabs? | Excel Worksheet Functions | |||
| How to automatically update a 12 month budget | Excel Discussion (Misc queries) | |||
| What formula will get a cell to update when the month changes | Excel Worksheet Functions | |||
| automatically update chart plotting current month and previous 6 | Charts and Charting in Excel | |||
| Update Month | Excel Discussion (Misc queries) | |||
Linear Mode
