Average dates

[MrsFrankieH]

Hello everyone!!

My computer is a laptop (ASUS)

My operating system is Windows 10.

I would like to know if it is possible to find a formula that will help me to figure out the average days, months and years between the following dates. I will be adding dates, so the formula would have to adjust to calculate additional dates. I appreciate your help in advance and I hope you all are safe and healthy.

Thank you.

 

[StephenCrump]

I have no idea what your dates represent, so my comment was just a general one ...

If the date differences are random, a guess of +208 days is as good as any other.

But if there is some structure to the data, you might be able to make a better guess. For example, if the dates represent the occurrence of bushfires, you'd expect strong seasonality, and your best guess for the interval to the next fire will probably vary depending on whether it's summer or winter now.

Or if the dates are reported measles cases, you'd expect clustering (and perhaps seasonality) and your guess might be adjusted to take account of both.

 

[MrsFrankieH]

Oh, I understand now Stephen. My dates represent a particular group of lottery numbers so I guess, due to the randomness of the numbers, maybe the seasonality aspect may not produce the desired results. The formula you created for me is perfect and I appreciate your help immensely. Thanks again friend.