Return date if two columns have the same date

[pvp]

Hi there,

I wanted to use the IFs formula to check if the between 2 out of 6 columns the date matches ( so if they show the same date).
However I do not receive the date 30.01.2007 if I apply the formula even though columns CV and CY have the same date.
Does someone know what I need to do to make it work?

Many thanks in advance for any suggestions.

Regards
Philpi

[Glenn Kennedy]

Please update your profile to show your curent Excel version. Clearly, you are no longer using Excel 2003 (.xlsx attachment).

[Fluff13]

The problem is that CP103 & CS103 are blank there they equal each other & the formula returns CP103.
You are obviously not using 2003 any more so please update your profile, depending on your version try
=MODE(IF($CJ$4:$DB$4="Datum",CJ103:DB103))

It may need CSE entry

[pvp]

The problem is that CP103 & CS103 are blank there they equal each other & the formula returns CP103.
You are obviously not using 2003 any more so please update your profile, depending on your version try
=MODE(IF($CJ$4:$DB$4="Datum",CJ103:DB103))

It may need CSE entry

Dear Fluff,
thnak you very much.
Your solution worked right away for me.
And I should have noticed that the reason I receive blank as a result is that 2 columns had a blank date
I have O365 installed on my pc.

[Fluff13]

You're welcome & thanks for the feedback.