SOLVED

Excel- count cells with date within the last year

New Contributor

Hi, 

 

I have a database where we record compliance for training. To be compliant the date they completed the course must be within the last year, after the year they are non compliant again. 

 

Can someone help me with a way to count the number on cells in a column where the date is within year from today (so we can calculate the number compliant quickly) 

 

We already have it set that the cell goes red when the training is expired 

 

Thank you  

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@Abzhelen 

=COUNTIF($B$1:$B$27,">="&TODAY()-365)

You can try this formula.

countif.JPG 

@Quadruple_Pawn Thank you! This worked perfectly