Calculating dates due to expire

[Kapcha]

Hello,

I have look all over and all codes i have tried are failing on me and im starting to struggle to find a solution.

In I8:I200 i have various deadlined dates, i have done conditional formatting to hightlight all the dates which are due to exspire within the month (30days), This was done buy having =NOW() in cell A1.

In cell E4 i would like a number which counts the amount of dates that are due to expire (ones in highlighted).

Any tips on how this is done.

Regards

[royUK]

Use Countif

=COUNTIF(I8:I200,">" &TODAY()-30)

You also can use TODAY() in the Conditional Format formula instead of in a cell

[Kapcha]

Hello,
Thank you for your reply, i use this code and it works however, when i add a date like 20/05/2012 which is 3 months away its still calculates that?

Cheers