Link to home
Start Free TrialLog in
Avatar of Anthony Mellor
Anthony MellorFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Combine THREE columns of dates from different sheet? Example file attached that does two.

the "report" flag is because I reported a feedback problem.

example file:  EEDATESCOMBINE3.xls
This formula joins two date columns from different sheets, how to join a third? Preferably without embedding this formula inside itself.

LET(
RowCount1,ROWS(DatesOne),
RowCount2,ROWS(DatesTwo),
Rowindex,SEQUENCE(RowCount1+RowCount2),
IF(Rowindex<=RowCount1,
INDEX(InputData[DateDuePaid],Rowindex),
INDEX(DDSO[DATE],Rowindex-RowCount1)))
ASKER CERTIFIED SOLUTION
Avatar of Ejgil Hedegaard
Ejgil Hedegaard
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Anthony Mellor

ASKER

1984 me too :-)
Anthony