IF Date is Between Two Dates or IF Date is Between Range Then How to get Return Value ? In LibreOffice Calc using Formula?

[sv.thiyagarajan]

Hi Friends,
How to get the Value or Result , If The Date is Between Two Dates or IF Date is Between Range ?
I Can get the Result in MS Office 365 and Office 2021 Using Filter Formula Function
and Other previous Version Using with
Combination Of Multiple Formule
=INDEX(C11:C17,MATCH(1,–(E11>=A11:A17)*–(E11<=B11:B17),0))

1)MS Office 365 / Office 2021 - Using Filter Function

2. Other Previous Version Of MS Office 2019, 2016 etc…
   ============================================
   =INDEX(C11:C17,MATCH(1,–(E11>=A11:A17)*–(E11<=B11:B17),0))
   

[Villeroy]

With any spreadsheet program since Visicalc of 1980: =LOOKUP(E11;$A$11:$A$17;$C$11:$C$17)

[sv.thiyagarajan]

Thanks… Yes, I tested Random Dates, which is between Start Date and End Date , Its Perfectly gives Result… and I learned This LoopUp Formula Function have in almost all the Office Programms…Like LibreOffice, MS Office, Google Sheet… etc…