#Invalid data type, year function
Hello, I would like to return the year from a MM/DD/YY cell.
Here is the formula I'm using:
I have confirmed that the "event start date no time" is column type date:
But I'm still getting an #Invalid Data Type as the result.
Here is my guess as to why:
The "event Start Date No Time" column is a "helper" column which I used to convert the start date with time column to just a start date, so that I could preserve the time in the previous column. (if I convert that column to date type directly, I loose the time value, which I do need). I want this to remain a column function so that as I add data to this sheet it continues to populate, but I also need for this year formula to pull automatically. Any ideas for how I can get this to work?
Help Article Resources
Check out the Formula Handbook template!