I have a sheet with three columns:

colA  colB  colC

colA and colB should show a date and are formatted to xx/xx/xx e.g: 12/03/24 or there may be no date.

There is a formula that will populate or make zero colA:  =IFERROR(INDEX($B$2:$BN$2,AGGREGATE(15,6,COLUMN($B$2:$BN$2)/(L8:BX8<>””),1)-1),)

If this formula produces a date all is well. But if there is no date to show in colA I see this: 00/01/00

So yes, I turn of ‘show zeros’ in preferences. But the formula in colC which is designed to consolidate colA and colB sees this “zero” date result and fails. By failure I mean nothing shows in colC when the correct result in colC should be the content of colB

​I have a sheet with three columns:colA  colB  colCcolA and colB should show a date and are formatted to xx/xx/xx e.g: 12/03/24 or there may be no date.There is a formula that will populate or make zero colA:  =IFERROR(INDEX($B$2:$BN$2,AGGREGATE(15,6,COLUMN($B$2:$BN$2)/(L8:BX8<>””),1)-1),)If this formula produces a date all is well. But if there is no date to show in colA I see this: 00/01/00So yes, I turn of ‘show zeros’ in preferences. But the formula in colC which is designed to consolidate colA and colB sees this “zero” date result and fails. By failure I mean nothing shows in colC when the correct result in colC should be the content of colB  Read More

​