Notifications
Clear all
Topic starter
Hi,
In the table here -
Each customer should get his first date from the data table,
I performed with the Minifs function
But there are customers that are written 01/01/1900 - this is not correct
And I need a function instead of Small - write another formula -
That you know how to pull out the customer's minimum date -
Which came immediately after 01/01/1900
Dodge customer number 12593 - should be accepted on 20/03/2016
Thank you very much for your help!!
Leah
Posted : 12/11/2021 1:03 am
Couldn't you just add another criterion to the MINIFS that the date in B has to be >1?
Posted : 12/11/2021 6:35 am