Is there a revised formula that will allow me to show more accurate training dates?
I have a formula in a training matrix that compares dates of when a document revises and when the training was carried out for employees.
=IF([Revision Date]@row > [employee]93, true, false)
However, this returns a red font date if the revision date is greater than the training date, even if the employee was trained prior to the finalization of the revision date. I am wondering if this formula could be modified to account for the revision date - 5 days to not flag trainings that happen just before the revision occurs, pre-emptive training before official revision.
Help Article Resources
Check out the Formula Handbook template!