Possible simple question regarding a formula and a blank cell.

Dear Excel-specialists,

I have a problem that can be split in two questions.

1. I like to show the date that is the most nearest to the current date --> that is: the dates that are filled in the three columns seperatly (a1, b1, c1)
2. When a date field is not filled in, I get the value "-44736" back . Is it possible to remove that value and just show what I need --> question 1 (without the value -44736)?

Please see the attached file for more context. I can't figure it out.
Thank you in advance for your help!

Best regards,


Hans

Hi WideBoyDixon,

This works like a charm (and even improved the current syntax). Thank you very much for your help/support!! :-)

Best regards,

Hans

PS.
Adding reputation.

Hi WideBoyDixon,

I have just one additional question.
I get a #N/B error when a date field is left blank (please see attached file). Is this easy to solve?
Thank you in advance for an answer

Best regards,

Hans