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