In the first formula, you are calculating a month number (1), adding 3 to it
to get 4. Then, when you format this as a date, you are telling Excel to treat
the number 4 as a date, i.e. as 4 days since "Day 0" which is Dec 31, 1899.
That's Jan 4, 1900. When you format that as "mmm" you see Jan.

In the 2nd formula you calculate a date that is 45 days from today. That's Mar
3, 2005. Again you extract the month from that date, which is 3. Then via
formatting you tell Excel to treat 3 as a date, or 3 days since 12/31/1899, or
Jan 3, 1900, and then display that date showing only the month. The result is
again Jan.

If you want to display the date 45 days from today, showing just the month,
it's

=TODAY()+45

and format the cell as "mmm". You don't use the MONTH function at all.


On Mon, 17 Jan 2005 13:55:05 -0800, Compass Rose
wrote:

When I enter the formula =MONTH(TODAY()) and the cell formatting is set to
General, the cell contains a 1.
When I change the cell formatting to Custom "mmm", the cell displays "Jan".
So far, so good.
When I enter the formula =MONTH(TODAY())+3 and the cell formatting is set to
General, the cell contains a 4. I would assume that this is the correct
formula for showing the month which is 3 months hence. When I change the
formatting to Custom "mmm", I would expect the cell to contain "Apr", but it
doesn't. It still displays "Jan".
When I enter the formula =MONTH(TODAY()+45) and the cell formatting is set
to General, the cell contains a 3. I would assume that this is the correct
formula for showing the month which is 45 days hence. When I change the
formatting to Custom "mmm", I would expect the cell to contain "Mar", but it
doesn't. It still displays "Jan".

I'm stumped.

TIA,
David