I have a tracker that keeps up with people's tasks.
A1= date task is completed in YYYYMMDD
A2=adds 365 days to show next due date
A3=shows 90/60/30/0 days based on A4
A4=shows how many days left until it's due and when it hits 0(zero) it shows "OVERDUE"
I have successfully used the formula. A4=IF((A3-NOW())<0,"OVERDUE",A3-NOW()) to show days left and OVERDUE
My goal is when I initiated a task, I will enter, "INIT" in A1 and A4 will show "OVERDUE". A4=IF(A1="INIT","OVERDUE",0)
Asking for assistance to have both IF statements in one cell.
Thank you for your help!
-Michael
A1= date task is completed in YYYYMMDD
A2=adds 365 days to show next due date
A3=shows 90/60/30/0 days based on A4
A4=shows how many days left until it's due and when it hits 0(zero) it shows "OVERDUE"
I have successfully used the formula. A4=IF((A3-NOW())<0,"OVERDUE",A3-NOW()) to show days left and OVERDUE
My goal is when I initiated a task, I will enter, "INIT" in A1 and A4 will show "OVERDUE". A4=IF(A1="INIT","OVERDUE",0)
Asking for assistance to have both IF statements in one cell.
1 | 2 | 3 | 4 | |
A | 20190101 | 20191231 | 0 | OVERDUE |
B | INIT | OVERDUE | ||
Thank you for your help!
-Michael