Forum Discussion
Formula Help
Harry2145 Everything (almost) is possible, but what's the logic. To set an end date to a project doesn't mean that it's completed once that date has passed. Add a column for Completion date and a formula like
=IF(date_completed <= TODAY(), "Complete", "Late")
Riny_van_Eekelen thank you for the reply and attached formula, I have used this in my workbook and works well, however can I change the message so that in the last column it will show DUE THIS WEEK which is highlighted in red
Harry2145 Like so? See attached. I just removed the conditional format and changed "TRUE" to "Due this week" and removed the heading.
- Riny_van_Eekelen that is great thank you very much, when this moves onto next week can the existing due this week be changed to completed in green and then next week what ever is due for the week will show as due this week
Harry2145 Everything (almost) is possible, but what's the logic. To set an end date to a project doesn't mean that it's completed once that date has passed. Add a column for Completion date and a formula like
=IF(date_completed <= TODAY(), "Complete", "Late")
- Riny_van_Eekelen thank you for the update, in the due this week column will the message disappear if it is not due for this week and next week it will change depending on which task is due, I want previous due this week to disappear as the weeks go by