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;

[TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD]Surname[/TD]
[TD]1st name[/TD]
[TD]Process1[/TD]
[TD]Process2[/TD]
[TD]Process3[/TD]
[TD]No. of retrains[/TD]
[/TR]
[TR]
[TD]Graham[/TD]
[TD]Ian[/TD]
[TD]16/08/2011[/TD]
[TD]16/04/2012[/TD]
[TD]16/01/2011[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Carter[/TD]
[TD]Richard[/TD]
[TD]03/08/2012[/TD]
[TD]10/04/2012[/TD]
[TD]01/07/2012[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jones[/TD]
[TD]Simon[/TD]
[TD]19/04/2011[/TD]
[TD]31/10/2011[/TD]
[TD]21/08/2012[/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]


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!