Good Day,
I hope this question finds you well.
I was hoping someone can assist me with the following please.
I want to know how many days an output is behind/delayed or how many days are still available (to show in column J) compared to its original due date (column D) compared to today's date every time. The date for the day you open the sheet to view.
This should also be depended on the status in column H, status. If the project is "achieved" within the due date period then the number of days can still be shown in column J to show that an output was delivered ahead of time. If the project is "in progress" the column J w/days can be shown in light blue IF the project is not past its due day. If projects are past its due dates according to column J then an "in progress" the row should be red. Once a project that was red is changed to "achieved" when the output has been completed finally the cell (column J) with the negative delayed number of days should remain in red. This will help me to know that even when projects are now in the "achieve" status and basically completed it will still show me that its due dates where missed.
The work days should also excluded Saturdays and Sundays and holidays in the sheet.
I hope this makes sense.
I have attached an example of how is should look like with some values.
I thank you in advance.
Kind Regards,
Ray
Bookmarks