already999
New Member
- Joined
- Feb 19, 2025
- Messages
- 7
- Office Version
- 2010
- Platform
- Windows
Hi, I have 2 dates calculated with a formula (index, match) that I want to combine in 1 cell. It seems not to work with the Text formula.
Formula INDEX(Data!A:A;MATCH(MAX(Data!B:B);Data!B:B;0)) and INDEX(Data!A:A;MATCH(SMALL(Data!B:B;COUNTIF(Data!B:B;"<=0")+1);Data!B:B;0))
How can I have those calculated dates formatted in one cell?
Thanks for your help
Formula INDEX(Data!A:A;MATCH(MAX(Data!B:B);Data!B:B;0)) and INDEX(Data!A:A;MATCH(SMALL(Data!B:B;COUNTIF(Data!B:B;"<=0")+1);Data!B:B;0))
How can I have those calculated dates formatted in one cell?
Thanks for your help