Concatenate formula stop from certain row onwards in a large table

[ASLAMNOORI]

I have 6 dates columns of date, column 'S' to 'X' where data is only in one of these columns. I need that date in one column and to this effect I put this formula in next column 'Y' as follows
=TEXT(S3,"DD-MM-YYYY")&" "&TEXT(T3,"DD-MM-YYYY")&" "&TEXT(U3,"DD-MM-YYYY")&" "&TEXT(V3,"DD-MM-YYYY")&" "&TEXT(W3,"DD-MM-YYYY")&" "&TEXT(X3,"DD-MM-YYYY")
My table is of 103194 rows. Above formula perfectly works till the row number 72290 but afterwards till end, result is 00-01-1900.
I will be obliged if someone will please guide why this could happen and what additional formula be there to get blank reply for blank cells of dates.

 

[Eric W]

Hard to say why it stops working on row 72290. Could it be that the cell format changes? Or is it that after that point, all the cells are empty?

See if this works for you:

=IF(MAX(S3:X3)=0,"No date",TEXT(MAX(S3:X3),"DD-MM-YYYY"))

 

[ASLAMNOORI]

Hard to say why it stops working on row 72290. Could it be that the cell format changes? Or is it that after that point, all the cells are empty?

See if this works for you:

=IF(MAX(S3:X3)=0,"No date",TEXT(MAX(S3:X3),"DD-MM-YYYY"))

Bravo !
Dear Eric W

You made my day. Everything is perfect. I simply edited above replacing " " instead of "No date" as I needed a blank cell.
Still do not know why my formula stopped working from a certain row onwards till the end. Anyways all is well when ends well.

 

[Eric W]

Happy to help! Thanks for the feedback.