Dates -well months anyway

[Billy Two Hats]

How do I get the equivilant of =TEXT(MONTH(A1)+1,"mmmm") to show the next
calander month after the one recorded in cell A1? Cell A1 is formated as
mmmm, yyyy and is entered as the last day of the month. The result needs to
be formated as text, for use with an indirect function.

Using = MONTH(A1)+1 works in giving the number of the next calander month
but any of my attempts to show the actual month always gives January (ie
1/1/1900).

Thanks
Dave

 

[Anon]

How do I get the equivilant of =TEXT(MONTH(A1)+1,"mmmm") to show the next
calander month after the one recorded in cell A1? Cell A1 is formated as
mmmm, yyyy and is entered as the last day of the month. The result needs to
be formated as text, for use with an indirect function.

Using = MONTH(A1)+1 works in giving the number of the next calander month
but any of my attempts to show the actual month always gives January (ie
1/1/1900).

Thanks
Dave

You have to supply a date to the TEXT function, not a month number.
So, the month of the date in A1 would be given by
=TEXT(A1,"mmmm")

Since you say that the date in A1 will always be the last day of the month,
adding 1 will give the first of the next month, so to get the next month in
text you could use
=TEXT(A1+1,"mmmm")

 

[Geof Carrington]

-----Original Message-----
How do I get the equivilant of =TEXT(MONTH(A1)+1,"mmmm") to show the next
calander month after the one recorded in cell A1? Cell A1 is formated as
mmmm, yyyy and is entered as the last day of the month. The result needs to
be formated as text, for use with an indirect function.

Using = MONTH(A1)+1 works in giving the number of the next calander month
but any of my attempts to show the actual month always gives January (ie
1/1/1900).

Thanks
Dave






.
Billy

You're only wearing one hat for this one, namely your
formula hat.
Now put on the other hat, the format hat. Try formatting
the cell as a custom date using mmm and, if you're lucky,
it will duly appear the way you want it.

Geof

 

[Geof Carrington]

-----Original Message-----


That may well be so, but it doesn't answer the OP's question, which
included: "The result needs to be formated as text, for use with an indirect
function."


.
Don't know if you're the same Anon but, if so, 'twas

yourself pointed out to me that the cell format may
override or, at least, affect the working of the formula
or the eventual representation.

One must have both elements right, not only one.