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.
Last Date with a 0 - TODAY()
Could one of you Excel pros help me out on this one please?
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.
Last Date with a 0 - TODAY()
Could one of you Excel pros help me out on this one please?
Last edited: