Days between two dates the hard way

[anwaee2]

I have dates in A6:A41. In column B6:B41 I have some check marks. I am trying to find the days between the last two check marks in column B. There will be blank cells between the check marks. I have googled and googled and can't come up with an answer any where. You have been a big help in the past and I thank you very much for that. Hope you can help me here. Thanks in advance for any help you can give me.

 

[anwaee2]

Sorry, it should have read:
I have dates in A6:A41. In column B6:B41 I have some check marks. I am trying to find the days between the dates in column A ithat are in the same row as the last two check marks in column B. There will be blank cells between the check marks. I have googled and googled and can't come up with an answer any where. You have been a big help in the past and I thank you very much for that. Hope you can help me here. Thanks in advance for any help you can give me.

 

[JoeMo]

Is this what you want?

Excel Workbook
	A	B	C
5	Date	Check	Days Between
6	8/1/2019	X
7	8/2/2019	X	1
8
9
10
11	8/6/2019	X	4
12
13
14
15
16
17
18	8/13/2019	X	7
19
20
21
22
23
24	8/19/2019	X	6
25	8/20/2019	X	1
Sheet2

 

[anwaee2]

Not quite. I should have mentioned that there will be dates in every cell in column A. What I have is a spreadsheet with dates in column A and columns B thru 6 are the tasks that can be performed. Not every task will be performed on each date. I would like to have a cell at the bottom of each task letting me know how many days between the last two times the task was performed. Thank you for getting back, just sorry I didn't explain it very well.

 

[JoeMo]

That's a long way from the description in your OP. You might improve your chances of getting a solution if you post some sample data in a form that can be copied from a browser and pasted to Excel.

 

[anwaee2]

Sorry, I relize that now. Hopefully I won't make that mistake again. Thank you again for your trouble.