I have a spreadsheet (Shocking... I know) with a bunch of dates and data (again... I will let the shock wash over you)
I am using an IF statement to say if "date" is over 3 days ago put YES, if not, put NO same for 10 days, 20 days, and 30 days... All of that works... but when I go to do a count at the end the total is greater than the number of dates because if a date is greater than 10 days it is obviously greater than 3 days and 5 days and it gets counted in each of those columns also.... (see below)
Is there any way to make it only count each row once (the oldest date)
maybe something with lookup formula and some other math between created date and today()? I would rather not go that route...but I am open to anything....
Appreciate any help
I am using an IF statement to say if "date" is over 3 days ago put YES, if not, put NO same for 10 days, 20 days, and 30 days... All of that works... but when I go to do a count at the end the total is greater than the number of dates because if a date is greater than 10 days it is obviously greater than 3 days and 5 days and it gets counted in each of those columns also.... (see below)
Is there any way to make it only count each row once (the oldest date)
maybe something with lookup formula and some other math between created date and today()? I would rather not go that route...but I am open to anything....
Appreciate any help
1/3/2023 | 12/27/2022 | 12/17/2022 | 12/7/2022 | |
15-Dec | Yes | Yes | Yes | No |
12/31/2022 | Yes | No | No | No |
1-Jan | Yes | No | No | No |
5-Jan | No | No | No | No |
12/14/2022 | Yes | Yes | Yes | No |
12/13/2022 | Yes | Yes | Yes | No |
12/12/2022 | Yes | Yes | Yes | No |
12/11/2022 | Yes | Yes | Yes | No |
12/10/2022 | Yes | Yes | Yes | No |
12/9/2022 | Yes | Yes | Yes | No |
12/8/2022 | Yes | Yes | Yes | No |
12/7/2022 | Yes | Yes | Yes | Yes |
12/6/2022 | Yes | Yes | Yes | Yes |
12/18/2022 | Yes | Yes | No | No |
12/16/2022 | Yes | Yes | Yes | No |
Total | 14 | 12 | 11 | 2 |