Want to compare a date field to a static date
I have a sheet that has both a date field and a system-generated date created field. I want to use the date field (Called "Actual Start") in this column formula to show the "Actual Start" date if that date is before July 30, 2022. Otherwise, I want the cell to be populated with the System-generated date created field. I can't seem to define how to do the compare of the Actual Start date field to the static July 30, 2022 date. Any help will be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!