I have a group of cells formatted as follows:
NOV 06 2015
NOV 12 2015
FEB 20 2015
AUG 03 2014
etc.
I have been trying to use a TEXT formula to the corresponding date and using a LEFT, MID, and RIGHT within the TEXT formula to covert to date but no luck. Any help appreciated. Thanks
Hi,
One way
Formula:
Please Login or Register to view this content.
YOU could also create a separate VLOOKUP table in order to get the month number and avoid the LOOKUP function and shorten the formula a little.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Try this formula
Formula:Please Login or Register to view this content.
Format as Date
Data Range
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Both work. Thanks
You can use Text to Columns to convert the strings into real dates. No formulas needed.
Select the cells in question
Data>Text to Columns
Select Delimited
Click Next twice
In Step 3 of the Userform, under Column data format, select Date MDY
Click Finish
Format in the date format of your choice
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Glad to have assisted and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks