MATCH in an unsorted list - non-value

[Mister64]

Hello, ANYONE

Here's my problem

i want to do this: MATCH(<int(now()),$P$3:$P$1048,0)

Now it doesn't work , and I can't find a way of doing it.

I already use a variation on this that works fine but Excel doesn't like the <

Anyone got any ideas?

[daddylonglegs]

Can you explain what you want to do. Is the list a list of dates, unsorted?

You want to find the largest date in the past? Try

=MAX(IF(P3:P1048<today(),P3:P1048))

confirmed with CTRL+SHIFT+ENTER