Formula for Future Dates "IF"
I want to create a formula that will highlight a date based on an entry date and type.
Example.
IF entered AAA on August 23, 2024, after 18M months it is flagged
IF entered BBB on August 23, 2024 after 24 months it is flagged
Is this possible and any recommendations on how to complete the formula? I’ve failed a few times.
I want to create a formula that will highlight a date based on an entry date and type. Example. IF entered AAA on August 23, 2024, after 18M months it is flaggedIF entered BBB on August 23, 2024 after 24 months it is flagged Is this possible and any recommendations on how to complete the formula? I’ve failed a few times. Read More