Using COUNTIF on a range of dates

[Ian_G]

Hi All,

I'm having a stupid moment, so hopefully this shouldn't take long to put right!

Basically I'm trying to create a matrix which allows me to see the number of processes in which an individual would need retraining for number of processes (Which needs to be done on yearly basis). In order to do this I have created a sheet which allows me to enter the date on which a user was trained;

Surname	1st name	Process1	Process2	Process3	No. of retrains
Graham	Ian	16/08/2011	16/04/2012	16/01/2011
Carter	Richard	03/08/2012	10/04/2012	01/07/2012
Jones	Simon	19/04/2011	31/10/2011	21/08/2012

<TBODY>
</TBODY>

The formula I'm trying to use in the "No. of retrains" column is as follows;

=COUNTIF(C2:E2,"<=(TODAY()-365)")
=COUNTIF(C3:E3,"<=(TODAY()-365)")
=COUNTIF(C4:E4,"<=(TODAY()-365)")


But on each row it keeps returning 0!

Can somebody be kind enough to point out where I went wrong?

Thanks in advance.

 

[VoG]

Try like this

=COUNTIF(C2:E2,"<="&TODAY()-365)

 

[Ian_G]

Nice one VoG!

I knew I was being an idiot, I just couldn't see what the fault was!

Anyway that has worked a dream, thank you very much!