Count column of dates older than a year

[alleny87]

Hello All,

So I have a report generated, listing all my companies personnel in one column and the next column has the expiration dates of a certian training certificate. My question i would like to add some statistics to the bottom of the report, mainly how many certificates are expired, which is the ones over a year.

I have attempted to use:

=Sum(IIf([AT_LEVEL 1]<"Now()-365",1,0))

previously in excel my spreadsheet counted it like this:

=COUNTIF(C5:C77,"<"&TODAY()-365)

any help would be appreciated, im struggling here

 

[pbaldy]

Close, try

=Sum(IIf([AT_LEVEL 1]<Now()-365,1,0))

 

[alleny87]

It works, thank you, I knew I was somewhere in the ballpark. I really appreciate it

 

[pbaldy]

No problem, and welcome to the site by the way!