sleevedfreak
New Member
Ok this is my first post so forgive me if I do not give all the details in this first one. I am working on a tracker for my work. The basic is when I receive Input A my team has 30 days to deliver Input A.
I have the formula for "Schedule date" as the following : =IF(F2="","",(F2+30))
This gives me the Schedule date, which I have a column that shows "On Schedule" and "Overdue" the formula is: =IF(ISBLANK(F2),"",IF(H2<TODAY(),"Overdue","On Schedule"))
The problem I have with the above is that when I put in my Issue date, the column that has the On Schedule and Overdue, will still change once today's date is past the due date. How to i modify the formula using the AND or OR or add something to this to the column AD that i enter the issue date?
View attachment 78068View attachment 78069
Thanks
I have the formula for "Schedule date" as the following : =IF(F2="","",(F2+30))
This gives me the Schedule date, which I have a column that shows "On Schedule" and "Overdue" the formula is: =IF(ISBLANK(F2),"",IF(H2<TODAY(),"Overdue","On Schedule"))
The problem I have with the above is that when I put in my Issue date, the column that has the On Schedule and Overdue, will still change once today's date is past the due date. How to i modify the formula using the AND or OR or add something to this to the column AD that i enter the issue date?
View attachment 78068View attachment 78069
Thanks
Last edited: