Why some date is signed "invalid date"?

Hi all,

I want to convert my date list(e.g. 2/7/2018)in an excel file into a day of the week list(e.g. Monday). However, some of the results show the error, and the error is "2/7/2018 is not a valid date" or "Monday is not a valid date".

Could anybody help me with it?

Thanks a lot!

Date Time

Accepted answers

grossal

Would you mind accepting the post as a solution? 😃

All comments

grossal

Hi @PhilipW,

are you able to post some sample data where the errors occur?

Best

Alex

PhilipW

Hi Alex,

The attachment is my dataset. I also have a screenshot below. Honestly, these dates show no difference from the other dates.

Thanks!

BioPhirma_datafile.xlsx

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703