Concatenate two date

[Lisa P NYC]

Can someone please help me...it's driving me crazy?

I have 2 columns that contain dates. I am getting the data for those two columns from 2 other sheets. (Formatted as dates on these sheets) There are NEVER two dates in the same row. I want to combine the information in the two columns into one separate column of dates. I need to use that column for a formula.

I first tried to concatenate the two cells =concatenate(A1,B1) didn't work
Then I tried =Text(A1, "mm/dd/yy")&Text(B1, "mm/dd/yy") This gives me the date and 01/00/00 for whichever column is blank. So it is either before the date or after the date depending if the date is in the first or second column.

All three columns are formatted to date. How do I combine the two columns and just show the date in the new column? The blank column seems to be the culprit.

I have searched Google, and YouTube and I just can't find an answer. Hoping that someone here can help.

Thanks - Lisa

 

[Fluff]

How about

=max(a1,b1)

 

[Lisa P NYC]

How about

=max(a1,b1)

 

[Lisa P NYC]

Fluff this is great, thank you. Can I ask you an additional question please? What if both rows in the column are empty? How do I stop it from returning the 1/0/00 ?

 

[Fluff]

How about

=iferror(1/(1/max(a1,b1)),"")

 

[Lisa P NYC]

How about

=iferror(1/(1/max(a1,b1)),"")

Absolutely amazing. I was truly getting ready to throw my laptop out the window. Thank you sooo much.

 

[Fluff]

You're welcome & thanks for the feedback.