Days Without Incidents

[dcherney]

Hey all, first time posting in here. I'll try to explain what I'm trying to do the best I can.

I'm looking to count the green cells (no incident) from the previous red cell (incident). I would like it to count automatically every time I either add the green color to a cell (date). Or start back at 0 if i add the red color into the cell (date). See below

Any help is greatly appriecated.

Thank you!

 

[Joe4]

Welcome to the Board!

One of the issues is that Excel formulas cannot run off of the formatting that is in cells. It can only run off of the values in those cells. So to do something off of the formatting would require VBA.

Another big factor is how these calendars are actually set up in Excel. Are you using Calendar Controls, or are the calendars simply just grids/tables you set up in Excel?
If the later, than another issue is that each entry in each cell is just a number, and not a valid date (making it much harder to do calculations off of it).

Really, the easiest way to make that an easy calculation is to actually enter the date of the last Incident in some static cell.
So, if it was cell Z1, then the number of days since the last incident would just be:

=TODAY()-Z1

Or it would also be simpler if you just had a log somewhere, where each day you are making an entry and indicating if there were any incidents or not.

Otherwise, I am not sure how you could do this without using some VBA.