Counting Conditionally Formatted Strikethrough Cells

[johndevitis]

I have a table with a lot of dates in it. The dates all expire, but some expire in 2 years, some in 3, and some in 5. I need to count the amount of expired dates in each column. I conditionally formatted the expired dates to switch to "strikethrough" font when it expires.

How can I count just the number of cells with strikethrough font in a column?

I google searched this and there are a few ways to do it, but they only work when I manually make a cell strikethrough. The solutions I found do not work on cells that are made strikethrough from conditional formatting.

 

[gaz_chops]

Welcome to the forum.

What formula are you using in conditional formatting?

Just re-read, I was going to suggest you could use same formula to count, but not if you are Manually formatting the cells.