What am I doing wrong here? I have a data set with date values formatted mm-dd-yyyy.
ex.
I am creating a new column with the day extracted from each date, but when I use DAY() function I get #VALUE. I've set the Date column to Date type but to no avail. Any insight would be appreciated.
Edit: Here is the DAY formula im using:
As @MayukhBhattacharya suggested above in the comments, the Text to Columns wizard fixed the issue.