Forum Discussion
Solved
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 we...
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 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
Harry2145 I believe so. Just give it a try.