Program expiration dates in excel
Posted on 2014-01-02
I like to create an excel file, where the days available between date certified and due date, will give me the results in red, amber, or green color.
Number of days since certification XX DAYS CELL 1:E
Due expiration date 4/8/2014 CELL 2:E
Date certified 4/8/2013 CELL 3:E
"Number of days since certification" in CELL 1:E will change from the result of "Date certified" in CELL 3:E and the current Date.
60 days before "Due expiration date" i need cell 4:E to become amber.
On "Due expiration date", i need cell 4:E to become red.
All other days before "Due expiration date", cell 4:E will be green.
Also CELL 4:E will show the amount of days left leading up to the expiration date.
Can someone give me feedback on this.