ExcelBanter - Automatically update month

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Automatically update month (https://www.excelbanter.com/excel-discussion-misc-queries/258940-automatically-update-month.html)

Smilingmom

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

Dave Peterson

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

Smilingmom

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
.

All times are GMT +1. The time now is 05:21 PM.