Pull month and year
Is there a way to pull the date and year from one column to another? I am currently using the following formula to pull the year out of the Report date column.
Report Column. Mandated Date Column
10/8/2020 =IFERROR(YEAR([Validation Report IA Date]@row) + 1, "")
I would like the "Mandated Date Column" to display the month/year (a year out). Is there a way to do this?
Any help would be appreciated.
Help Article Resources
Check out the Formula Handbook template!