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.
|Date||Day||Mow||Weed Eat||Yard Service||Seeded|
|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|