Formula to show date, i.e., Apr.01-31.2007?

[MitchellWMA]

I find I'm stumped. I have a spreadsheet that has manual dates in the
format of mmm.1stday-lastday.yyyy, i.e.,
Apr.01-31.2007
May.01-31.2007
etc.

The regional settings on my computer show dates as yyyy.mm.dd.

What I shall be doing is converting that text format to a date format
so that the dates look like this:
2007.04.01.
That part is easy.

However, how could one change the displayed date of the above to the
first format, that of mmm.1stday-lastday.yyyy? I will have about 3
different date types I need so getting the first one would be great.
I can then apply the principle to the other date formats.

---------------------------------------------------
So, if I start off with something like:
2007.04.01
what can be done to get the display of:
Apr.01-31.2007.
---------------------------------------------------

I ordinarily do this type of thing under the custom option in the
number formatting one does in cells. But needing the last day, which
will be a calculation I'm guessing, is what makes this one a toughie.

Thanks! D

 

[Rick Rothstein \(MVP - VB\)]

Just so we know, what was wrong with the three answers you got to this exact
same question when you asked it back on July 7th?

Rick

 

[recrit]

I find I'm stumped.  I have a spreadsheet that has manual dates in the
format of mmm.1stday-lastday.yyyy, i.e.,
Apr.01-31.2007
May.01-31.2007
etc.

The regional settings on my computer show dates as yyyy.mm.dd.

What I shall be doing is converting that text format to a date format
so that the dates look like this:
2007.04.01.
That part is easy.

However, how could one change the displayed date of the above to the
first format, that of mmm.1stday-lastday.yyyy?  I will have about 3
different date types I need so getting the first one would be great.
I can then apply the principle to the other date formats.

---------------------------------------------------
So, if I start off with something like:
2007.04.01
what can be done to get the display of:
Apr.01-31.2007.
---------------------------------------------------

I ordinarily do this type of thing under the custom option in the
number formatting one does in cells.  But needing the last day, which
will be a calculation I'm guessing, is what makes this one a toughie.

Thanks!  D

=EOMONTH([date], 0) .... 0 months will result in the last day of the
month for the date entered