LinkBack URL
About LinkBacks
Is there a way to change "APR - 24" to 04/30/2024, or "Dec-25" to 12/31/2025?
Cheers!
Patricio
Is there a way to change "APR - 24" to 04/30/2024, or "Dec-25" to 12/31/2025?
Cheers!
Patricio
Click Right mouse button on cell -> Format Cells -> Choose Date from category -> Choose Type -> OK
That doesn't work unless the value is already a date.
With your text in column A, try this copied down:
=EOMONTH(DATE(2000+MID(A1,FIND("-",A1)+1,2),MONTH(DATEVALUE(LEFT(A1,3)&" 1")),1),0)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Another way may shorter
=EOMONTH(DATEVALUE(1&A1),0)
Quang PT
Or
Formula:
Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
FormulaFormula:Please Login or Register to view this content.
Last edited by Czeslaw; 07-18-2023 at 01:32 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks