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")
Harry2145 Not sure how the start date comes into play here. A project is either due this week or it is not. The attached file contains an example that might help you find a solution. The formula in column G may seem a bit over the top but they assure that projects that will become due next year in the same week number are not "counted". I didn't go so far as to include a check for previous years projects though.
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")