Formula to Count Interval 'Streak' in Date Stamps (Google Sheets)

I have a sheet listing tasks in google sheets. Whenever a task is completed, the datestamp is logged in the row from column H onwards.
If a task is not completed in an interval shorter that the set period, then it has missed it's deadline.
I each task has a set interval for how regularly it should be completed. I want to be able to count how long a streak a given task has kept to the schedule.

Here is example data with the streak filled in manually
Period Streak Days Since 45,103 (logged date stamps)
Task1 14 5 1 45,102 45089 45076 45063 45050 45037
Task2 180 2 6 45,097 44935 44773 44548 44323 44098
Task3 7 3 0 45,103 45097 45091 45085 45076 45067
Task4 14 2 0 45,103 45090 45077 45060 45043 45026

Example sheet here https://docs.google.com/spreadsheets...gid=2100307022

So I need a formula that will count along the row, finding the length between pairs of date stamps, and counting how many periods have passed before a deadline was missed.
I have no idea how to set this one up. Any help would be greatly appreciated.

I have also added an excel file with the example data.

EDIT: I found my own solution (where timestamp logs start in column H)

Formula:

Please Login or Register  to view this content.

Since solutions in Google Sheets will not necessarily work in XLSX files, please share a Sheets file.

To share a file anonymously, you use this form to create a Sheets file into which you can build your sample:

https://docs.google.com/forms/d/e/1F...VbWiA/viewform

Thanks for sharing how to do that. This is my first time posting a Google Sheets question.

Here is my example sheet.
https://docs.google.com/spreadsheets...gid=2100307022

The following formula produces the same results as those shown in column C of the .xlsx file attached to post #1 and I believe that it will work in sheets.

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

Thanks JeteMc.
Unfortunately that doesn't actually work.
Your formula works only if the range is of the specific size. If the data size is larger, your formula undercounts. If the data size is smaller, your formula counts blanks as a streak.
Perhaps I should have made my example more messy.

The thing I'm trying to do is to count a streak as more time stamps are logged/inserted into the row. So I don't necessarily know how many timestamps there are. This means that there many be a long series to count, or there may be only a few followed by blanks.
I've adjusted the shared google sheet to make the problem clearer.

I managed to work out a solution.

Formula:

Please Login or Register  to view this content.

Hi truk2,

In case you're interested, here is an array formula you can just enter it into one cell in row 2 (no need to drag it down):

Please Login or Register  to view this content.

Originally Posted by janmorris

Hi truk2,

In case you're interested, here is an array formula you can just enter it into one cell in row 2 (no need to drag it down):

Thanks. I love getting additional takes, and improving my use of LAMBDA.
This solution does work, but it fails if the rows get sorted and the formula cell gets moved down the page. I do want to sort the data regularly, so I won't use this here, but saving the example.
Thanks again

"This solution does work, but it fails if the rows get sorted and the formula cell gets moved down the page"

That can be solved by dropping it into the header cell with the header added into the array:

Please Login or Register  to view this content.