Pivot Table Dates
I've created a pivot sheet using the Pivot App that includes a date of when a call was taken, however I'm having no success creating an actual date column from the column created by the Pivot App. Please see below for formula reference.
Temp4 proves that Call Date, which is the primary column is not a date, which is expected for a primary column.
In Temp1-Temp3 break that date into year, month, and day values.
However when I attempt to reassemble using DATE() in an actual date column, I receive an #invalid data type.
The Date column is formatted as date.
What am I missing? 🧐
Help Article Resources
Check out the Formula Handbook template!