Hi guys.
I need your help with the following.
Excel 2013
I am running a program that calculates the percentage of completion on a specific product.
1. I need to check if the product has reached 40% on a specified date(If on time: "on time"in green OR If not ,then cell must show "Late" in red)
So far i have the following
A1 =Today()
start date
B2: 06/09/2018
40% date - - 3 weeks later
C2 : 27-09-2018
Current Percentage 37% : Thus Late as today is 30-10-2018
I have the following formula: =IF(D2>40,"ON TIME","LATE")
Not sure how to incorporate the dates into this
Please can someone help
Bookmarks