'Is there a formula where I can update cell based on date and text in two cells
Objective Update Audit Status based Last Recertication Date, Review Cycle and Due Date. So that I can mark the Audit Status Column, Due, Complete or Late.
Key Data:
COLUMN E = Last Recertification Date
COLUMN K = Audit Status
COLUMN E = How Long is Certification Valid/Review Cycle (I.e. Monthly and Annual, Every 3 years)
COLUMN M = Due Date (This date already calculated based of column E)
Current Logic IF Last Recertification is in the past: Audit is complete/passed/due If the certification is in the future: Audit is not complete/not passed/ due
Solution 1:[1]
So, here is something thrown together, making some assumptions:
Do check the fine detail and check the vlookup table to see if it matches your needs.
Note, al the dates are formatted as dates.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Solar Mike |