[libreoffice-users] How to get max date < today from list

Environment:
OS:   Mac OS X Lion 10.7.5 (11G63)
LO:   Version: 4.3.7.2

/Before anyone is saying, please update first:
I am forced to be in an older version of LO (I can't update MacOS any
further on the hardware, so I can't update LO either).
Hence  I do not have MAXIF() or MAXIFS() available./

I am having a list of music (identified by numbers) sang or planned to sing
in tab '2018'
In another tab (in my case 'Last') I want to show the latest date the number
is sung. Of course if the date in the list is in the future I don't want to
show that..

I tried
{=MAX(IF(AND(A3='2018'.E1:E100;'2018'.B1:B100<TODAY());'2018'.B1:B100))}
This provides the wrong answer...

How can I accomlish what I want?

See 'Last'.B3

&lt;nabble_a href=&quot;TestMuzLijst.ods&quot;>TestMuzLijst.ods 




--
Sent from: http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy