uk date comparisons
=SUMPRODUCT(--($W$24:$W$33024<""),--(TEXT($W$24:$W$33024,"mmm-yyyy")="Nov-2006"),--($AA$24:$AA$33024<=25))
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
wrote in message
oups.com...
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.
|