Get instant live expert help on I need help with mm dd yyyy

“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

=IF(DATEVALUE(TEXT(F295,"mm/dd/yyyy"))<DATEVALUE(TEXT(4/23/18, "mm/dd/yyyy")),"XLN") --------------------------------- What is wrong with the above formula?
Solved by O. C. in 11 mins
help calculating hh or mm diff bet two dd/mm/yyyy hh:mm:ss AM/PM
Solved by S. E. in 11 mins
I need to save a excel 97-2003 file as a cvs file. But it is not keeping the excel date format of mm/dd/yy, it keeps going back to mm/dd/yyyy. Help!
Solved by K. E. in 14 mins
I need to automate the extraction of only the date (mm/dd/yyyy) from a column that has the date and time (mm/dd/yyyy hh/mm/ss)inputted into it via zapier. Using the LEFT function is not working
Solved by X. H. in 27 mins
I would like a formula to quality check the format of a date in column AD is dd/mm/yyyy
Solved by F. Y. in 18 mins