Date referencing problem

[lharcus]

Please help - I am trying to take a range of dates and count the number of dates greater than a date less three months.

If I use =COUNTIF('SPR List'!E:E,">17/02/02") it works ('SPR List'!E:E contains list of dates)

However, I want to carry this out without hard coding the date.

=EDATE(TODAY(),-3) gives me the date I want but I cannot combine the two commands.

Is this possible ??
Please help - it's driving me mad !!!!

[walding]

Perhaps VB will help?

i.e. Add a Sub in the open document event to enter the value of the date you want into the 'countif' cell?

[Aladin Akyurek]

On 2002-05-17 03:03, lharcus wrote:
Please help - I am trying to take a range of dates and count the number of dates greater than a date less three months.

If I use =COUNTIF('SPR List'!E:E,">17/02/02") it works ('SPR List'!E:E contains list of dates)

However, I want to carry this out without hard coding the date.

=EDATE(TODAY(),-3) gives me the date I want but I cannot combine the two commands.

Is this possible ??
Please help - it's driving me mad !!!!

Try:

=COUNTIF('SPR List'!E:E,">"&EDATE(TODAY(),-3))

[lharcus]

Thanks...it works.