ASLAMNOORI
New Member
- Joined
- Feb 16, 2014
- Messages
- 20
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.
=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.