EXCEL - Join date and text

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,



Below formula is returning date with numbers. can you please give me a solution where I can get date and text.

=IF(F2="FIBSMSAPTREM",TODAY()&B2,"") -------- 41019MR A A (B1 being MR A A)

I want 20/04/2012 Mr A A

1 reply

Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
=IF(F2="FIBSMSAPTREM",DAY(TODAY())&"/"&MONTH(TODAY())&"/"&YEAR(TODAY())&" "&B2,"")
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Better would be
=IF(F2="FIBSMSAPTREM", TEXT(TODAY(), "dd/mm/yyyy") &" "&B2,"")