IF & MIN via DATE - HOW TO Calculate?

[Sphinx404]

I have 2 columns. Date and # of Safe Days

The Date is starts on November 1 and is sequential through 2020.

The Safe Days column represents a 1 or 0
0 = Not a Safe Day
1 = Safe Day

I'm trying to figure out a calculation that will automatically give me the number of days since our last safety incident ( or since our last 0).

So if we had a safety incident at our facility on November 11, 2018.... Then my calculation would equal 22, since it has been 22 days since November 11th.

Could one of you Excel pros help me out on this one please?

Last Date with a 0 - TODAY()

 

[shg]

Duplicate post: https://www.mrexcel.com/forum/excel-questions/1079611-if-min-via-date-how-calculate.html

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).