Forum Discussion
Calculated Column with Dates and "IF"
I've been working on this for a bit and just can't find the correct syntax. if(([Created] > 6/30/21 and [Created] <7/1/2022), "2022", if(([Created] > 6/30/22 and [Created] <7/1/2023), "2023", "20...
RJF61 Please include the error when you post.
I do get the gist of what you are trying to do.
Here is a starter sample of what you were trying to do:
=IF(AND(Created>DATE(2021,6,30),Created<DATE(2022,7,1)),"2022",IF(AND(Created>DATE(2022,6,30),Created<DATE(2023,7,1)),"2023",""))
Please like and mark as best response if this helped you 🙂
Thank you so much Teacher.. you helped my life in Sharepoint a lot, I don't have to use power automate... All the best to you and family. 🙂