Conversion from Date to day name

0

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.

Answer
Discuss

Answers

0

Use this formula:

=TEXT(A2,"dddd")

Also, make sure your dates are formatted as dates and don't just "look" like dates.

Discuss
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'.

Discuss
-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.

Discuss

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: 1382) Oct 4, '16 at 8:56 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login