Convert Month name to date - last day of the month

[ifeelalone]

Is there any way to convert a Month name to date format? It should be the last day of that month and current year.

Example:

June should be converted to 06/30/2019
July should be converted to 07/31/2019

 

[kweaver]

First shot (must be something more elegant) with month name in column A, fill this down:

=DATE(2019,MONTH(DATEVALUE(A1&" 1")),DAY(EOMONTH(DATE(2019,MONTH(DATEVALUE(A1&" 1")),1),0)))

Or, for the future:

=DATE(YEAR(DATEVALUE(A1&" 1")),MONTH(DATEVALUE(A1&" 1")),DAY(EOMONTH(DATE(YEAR(DATEVALUE(A1&" 1")),MONTH(DATEVALUE(A1&" 1")),1),0)))

 

[Rick Rothstein]

Is there any way to convert a Month name to date format? It should be the last day of that month and current year.

Example:

June should be converted to 06/30/2019
July should be converted to 07/31/2019

Give this formula a try...

=EOMONTH(A1&1,0)

 

[ifeelalone]

First shot (must be something more elegant) with month name in column A, fill this down:

=DATE(2019,MONTH(DATEVALUE(A1&" 1")),DAY(EOMONTH(DATE(2019,MONTH(DATEVALUE(A1&" 1")),1),0)))

Or, for the future:

=DATE(YEAR(DATEVALUE(A1&" 1")),MONTH(DATEVALUE(A1&" 1")),DAY(EOMONTH(DATE(YEAR(DATEVALUE(A1&" 1")),MONTH(DATEVALUE(A1&" 1")),1),0)))

That worked! Thank you!

 

[ifeelalone]

Give this formula a try...

=EOMONTH(A1&1,0)

This one works for me too! and its simpler. Thank you!

 

[kweaver]

It's a great thing that Rick's here to keep these long-winded lines to a minimum!!! Thanks, Rick, as usual!

He obviously doesn't sleep much as it's VERY LATE in NJ. It's late in CA (for me), so hitting the sheets now.

 

[Rick Rothstein]

He obviously doesn't sleep much as it's VERY LATE in NJ. It's late in CA (for me), so hitting the sheets now.

Sleep? I am not familiar with that term, what is it? Yes, you are right, I don't sleep much, somewhere between 4 and 5 (usually closer to 4) hours a night.

I see you live in La Jolla, California. I just finished watching a movie and turned on CNN and see there was another, much larger earthquake in Ridgecrest which is about 225 miles from your city, so I am guessing you were not affected by it.

 

[kweaver]

Nope, neither quake had any shaking here. San Diego and the surrounds are not on a fault line so generally we remain in Paradise.
I use to live in NYC (Greenwich Village).