Dates -well months anyway

  • Thread starter Thread starter Billy Two Hats
  • Start date Start date
B

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
 
Billy Two Hats said:
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
Click to expand...

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")
 
-----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
Click to expand...
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
 
-----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
Click to expand...
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.
 
Back
Top