I apologize, I really got reamed for my last post (and justifiably so) and I will try to make it right this time as not to waste your time again. I would like to get the number of days between the last two dates in the date column that has the task columns checked (columns C, D, E & etc.). There will be no blank cells in the Date column (A6:A41) as far as it goes. Example: Days between last two yard services would be 45 days.. Date 4/22/19 is in cell A6 and date 9/5/19 is in cell A29. At the very least I need the row number of the last and next to last checked cells in any one column. And in formula form please, I am willing to use helper cells if necessary. And there are many more task columns that I didn't list here. Hope this is enough information. Thank you again for all the help in the past and a big thank you for any help you may provide now.
<tbody>
</tbody>
Date | Day | Mow | Weed Eat | Yard Service | Seeded |
04/22/19 | Monday | | | ✔ | |
05/14/19 | Tuesday | | | | |
05/20/19 | Monday | ✔ | ✔ | | |
05/21/19 | Tuesday | | | | |
05/30/19 | Thursday | ✔ | | | |
06/10/19 | Monday | ✔ | | | |
06/11/19 | Tuesday | | | ✔ | |
06/17/19 | Monday | ✔ | ✔ | | |
06/24/19 | Monday | ✔ | ✔ | | |
07/09/19 | Tuesday | ✔ | ✔ | | |
07/10/19 | Wednesday | | | | |
07/17/19 | Wednesday | ✔ | ✔ | | |
07/22/19 | Monday | | | | |
07/23/19 | Tuesday | ✔ | ✔ | | |
07/26/19 | Friday | | | ✔ | |
07/27/19 | Saturday | | | | ✔ |
08/01/19 | Thursday | ✔ | ✔ | | |
08/06/19 | Tuesday | | | | ✔ |
08/08/19 | Thursday | ✔ | ✔ | | |
08/15/19 | Thursday | ✔ | ✔ | | |
08/22/19 | Thursday | ✔ | ✔ | | |
08/29/19 | Thursday | ✔ | ✔ | | |
09/02/19 | Monday | | | | ✔ |
09/05/19 | Thursday | ✔ | ✔ | | |
| | | | ||
| | | | ||
Days From Today | 0 days | 0 days | 41 days | 3 days | |
Last Day Task Performed | 09/05/19 | 09/05/19 | 07/26/19 | 09/02/19 | |
Days Between Last Two Tasks |
<tbody>
</tbody>
Last edited: