I want to convert a date to a day name for example 30-09-2016 to Fri. Have tried numerous possible solution on google without success.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Conversion from Date to day name
0
Answers
0
Use this formula:
=TEXT(A2,"dddd")Also, make sure your dates are formatted as dates and don't just "look" like dates.
0
no need for VB here. See attached file. Convert your 'Date' to real (normal Excel date), then get the Day name (have both long and abbreviated names).
Don has the proper formula - I just added a conversion of your 'Date'.
-1
It was discovered, as you indicated that the date format in the spreadsheet was not an actual recognised date format. I could not convert it to date format either, luckily the file was not that big.
Thank you for the response.
Much appreciated.
Discussion
If you need help converting any dates, just post a new question along with a sample. Fixing the date format you used is really easy.
don (rep: 1989) Oct 4, '16 at 8:56 am