Forum Discussion
Formula Help
Hi All,
I need help in creating a formula which will take a start date from column E and a finish date in column F. If these two date ranges fall within what the current date is at the start of a week then I need column I to populate a message to say that the particular task is due this week which will be shaded red. Is it possible for a pop up message appearing also stating which tasks are due dependant on which particular week we are on
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")
7 Replies
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.
