Splitting DATE and Time column with Date Only in a new column
Hi everyone! I am hoping you can assist me. I have a column titled "Appt Date/Time" that has the date and time. Example: 1/1/2000 5:00. I have tried using the DATEONLY formula in a new column to extract just the date but keep getting an INVALID DATA TYPE error. I have verified the new column is a date column. Can someone assist me please?
Help Article Resources
Check out the Formula Handbook template!