Get instant live expert help on date format in excel formula

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have a column with the mixed date format. Some of them are in date format and some are in general format. I need everything to be in date format.
Solved by O. Y. in 15 mins
FILTER formula experiencing error because of non-standardisation of date format
Solved by M. H. in 27 mins
I'm copying date format 04/27/2018 and pasting in excel, however it does not recognize it as April 27, I did format date format to English (United States) but still not resolved the issue, if I paste a data 04/12/2018, it recognizes as December 4th. Please help!
Solved by G. J. in 13 mins
My Excel keeps crashing. Then my secondary problem is a incompatible date format..
Solved by I. H. in 20 mins
When I enter a date in the format 02-02, my Excel 2013 sets the date to 02-Feb. I need it to display Day-Month-Year in the format 01-01-****, can someone tell me how to change it so it will display this date all the time on all worksheets?
Solved by D. F. in 25 mins