Hi,
I'm really struggling to get the following thing working, basically
because nothing seems to like uk date formats.

Anyway, I have a column with dates in (uk format!), called finish, and
another column with numbers (time in days) in.

I want to calculate the number of rows with a finish date in a certain
month and a time of less than 25 (days). The finish date may be blank,
in which case I want to ignore these.

Currently I have ( as one of my many possibilities):

=SUM(($W$24:$W$33024<"")*(DATEDIF($W$24:$W
$33024,DATE(YEAR(TODAY()),MONTH(TODAY())-3,1),"m")=0)*($AU$24:$AU
$33024<=25)*1)

The 3 is just an example of the number of months I want to go back
from today

Thanks for any help.