IF, AND, OR Function
I trying to figure out how to write a IF statement that would allow me to match the value in one cell to a value in another cell on a reference sheet. If that value is true it needs to check that the date issued column on that row and make sure it is 1 year within today's date. If all that matches i need the cell on my current sheet to show red. Is this possible?
"Currently Has Discipline" is where the formula will go. It will need to match any number in the SSO column. (This number is dynamic)
I want to match this to a another sheet column "SSO" ( this number is dynamic) and also use "Date Issued " Column to check that the date is within 1 year of todays date. Then have that cell on my "Currently Has Discipline" sheet turn red.
Is this possible?
Help Article Resources
Check out the Formula Handbook template!