uk date comparisons
On Feb 19, 12:41 pm, Martin Fishlock
wrote:
Mark,
Try this :
=SUMPRODUCT(
--(TEXT($W$24:$W$33024,"MM.YYYY")=TEXT(TODAY(),"MM.Y YYY")),
--($AU$24:$AU$33024<=25),
--(ISNUMBER($AU$24:$AU$33024))
)
No need to check for blank dates as this uses the text date.
But need to check for blank days.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.
" wrote:
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.
Can I just ask why you have "--" in this formula?
|