Hi All,
I’ve been trying to think of a way to do this for ages.
I have users that complete certain tasks on certain days of the week (Mon-Fri Only), IDEALLY
There are rare occasions that they can be done before the due date but not after.
I have been using the following formula but it does have limitations.
D35 is the last date the task was completed.
=IF(AND(D35<=TODAY(),D35>TODAY()-7),"OK","Out of Date Data")
This gives me a rolling 7days around the last completed date, but if they complete the task early is causes problems.
If I use Thursdays task as an example, if they complete it on Wednesday, when the next Wednesday comes round, Thursdays task shows as “Update Required”
I have played around with the WEEKDAY formula but had no luck.
Any Suggestions?
Excel 2003
Neil
I’ve been trying to think of a way to do this for ages.
I have users that complete certain tasks on certain days of the week (Mon-Fri Only), IDEALLY
There are rare occasions that they can be done before the due date but not after.
I have been using the following formula but it does have limitations.
D35 is the last date the task was completed.
=IF(AND(D35<=TODAY(),D35>TODAY()-7),"OK","Out of Date Data")
This gives me a rolling 7days around the last completed date, but if they complete the task early is causes problems.
If I use Thursdays task as an example, if they complete it on Wednesday, when the next Wednesday comes round, Thursdays task shows as “Update Required”
I have played around with the WEEKDAY formula but had no luck.
Any Suggestions?
Excel 2003
Neil
Last edited: