How would I convert 201411 into a date. Nov 2014.
Thank you!
How would I convert 201411 into a date. Nov 2014.
Thank you!
Hi,
Give this a try. It assumes that your 201411 is in cell A1.
Hope this works for you.Please Login or Register to view this content.
Cheers
Try this
Formula:Please Login or Register to view this content.
Format as Date
or with this
Formula:Please Login or Register to view this content.
Last edited by AlKey; 04-02-2017 at 12:44 PM.
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
Thanks guys!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks