I am trying to make an =nl("First")-function where i need to filter based on data in the purchasing price table if the end date is equal og bigger than cell "Options!$C$3" but i also want to include date if the end date is blank. How do i do this?
I have made the following which works fine unless the end-date is blank - then there are no hits:
=@NL("Første";"Købspris";"Købspris";"Varenr.";D4;"Leverandørnr.";E4;"Min. antal";"<="&K4;"+Købspris";"*";"Startdato";"<="&Options!$C$3;"Slutdato"; ">="&Options!$C$3)
Its the last filter marked in bolt above.