I'm trying to calculate the average number of days between a list of dates, but there are blank cells in between just about every row with a date value. For example, A1=1/10/2020, A3=1/19/2020, A6=2/2/2020, and A10=2/18/2020. I could do this manually of course, but I want it to be able to passively update once new date entries are inevitably added.

Bonus Question: Next to each date entry (two columns over actually), is a value indicating number of hours elapsed from that date. How would I go about writing a formula that would incorporate those hours as well and then calculate the average length of time between the end of the previous denoted period (From Date_1 + Hours_1/24 to Date_2, and so on) and the beginning of the next one. Piggybacking on the above example, C1= 100 hours, C3=10 hours, C6=25 hours, C10=38 hours.

Any and all help is appreciated! Thank you!