Trying to redeem myself from being an idiot!

[anwaee2]

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
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>

 

[Eric W]

Something like this?

Book1
	A	B	C	D	E	F
1
2
3
4
5	Date	Day	Mow	Weed Eat	Yard Service	Seeded
6	4/22/2019	Monday	?	?	?	?
7	5/14/2019	Tuesday	?	?	?	?
8	5/20/2019	Monday	?	?	?	?
9	5/21/2019	Tuesday	?	?	?	?
10	5/30/2019	Thursday	?	?	?	?
11	6/10/2019	Monday	?	?	?	?
12	6/11/2019	Tuesday	?	?	?	?
13	6/17/2019	Monday	?	?	?	?
14	6/24/2019	Monday	?	?	?	?
15	7/9/2019	Tuesday	?	?	?	?
16	7/10/2019	Wednesday	?	?	?	?
17	7/17/2019	Wednesday	?	?	?	?
18	7/22/2019	Monday	?	?	?	?
19	7/23/2019	Tuesday	?	?	?	?
20	7/26/2019	Friday	?	?	?	?
21	7/27/2019	Saturday	?	?	?	?
22	8/1/2019	Thursday	?	?	?	?
23	8/6/2019	Tuesday	?	?	?	?
24	8/8/2019	Thursday	?	?	?	?
25	8/15/2019	Thursday	?	?	?	?
26	8/22/2019	Thursday	?	?	?	?
27	8/29/2019	Thursday	?	?	?	?
28	9/2/2019	Monday	?	?	?	?
29	9/5/2019	Thursday	?	?	?	?
30			?	?	?	?
31			?	?	?	?
32	Days From Today		0 days	0 days	41 days	3 days
33
34	Last Day Task Performed		9/5/2019	9/5/2019	7/26/2019	9/2/2019
35
36	Days Between Last Two Tasks		7	7	45	27
Sheet4

Cell Formulas
Range	Formula
C36	=INDEX($A:$A,AGGREGATE(14,6,ROW(C6:C31)/(C6:C31="✔"),1))-INDEX($A:$A,AGGREGATE(14,6,ROW(C6:C31)/(C6:C31="✔"),2))

You should also specify how you are creating the check marks. Is it by using a Wingdings type font? A UNICODE value? An actual check box? If so, is that linked to a cell we can reference for the TRUE/FALSE value? As it is, I just used the symbol in the formula, but that's easily changed.

 

[Eric W]

Also note that the HTML tool I used did not copy over the checks and boxes, but they should be the same as in your example.

 

[anwaee2]

Thank you so much Eric. I have tried ever formula (at least 3 dozen different ones that was suppose to work) that could find on google and none worked. Yours worked perfectly except for when there is only one entry in the task column but that is to be expected. Many thanks again. You are the man.

 

[Eric W]

Glad it works for you.