Dear Excel-specialists,
I have a short question, but first some additional context, including an attachment (the picture on the right provides a better idea of my challenge).
I have 4 columns (L:O)
Per row a person filles in 1, 2 or 3 dates --> column (L:N).
Column O shows the date that is closest/nearest to the current date (based on the dates that are entered in L, M, N)
This works perfectly, but if only 1 or 2 dates are entered, column O will not show a date.
Does somebody know what I am doing wrong?
I use this formula in the rows in column O --> (first formula is in Dutch, the other one in English).
=ALS(AANTAL(L3:N3)<3;"";MIN(L3:N3))
=if(count((L3:N3)<3;"";MIN(L3:N3))
Thank you in advance for an answer. :-)
Bookmarks