Date Formatting Problem

[meppwc]

I ran into an issue that I have never seen before
I am using a formula (=IFERROR(XLOOKUP(C315,AL!B:B,AL!G:G),"")&"") that, if found, will copy the date (4/30/2024) from the "AL worksheet to the "CMDB" worksheet.
The problem is the destination (where the formula is), keeps displaying the date as 45412.2364467593.
I have verified that the format on both worksheets is setup to display as a date, but the destination continues to display not as date 4/30/2024.

 

[Fluff]

Just use

=XLOOKUP(C315,AL!B:B,AL!G:G,"")

 

[Tetra201]

Try removing the &"" from your formula.

 

[meppwc]

Just use

=XLOOKUP(C315,AL!B:B,AL!G:G,"")

that worked and thanks............wonder why my formula didn't work. I use it often and never had this issue

 

[Fluff]

You were concatenating the value with "" which turns it into text.

 

[meppwc]

You were concatenating the value with "" which turns it into text.

OH..............that is good to know, appreciate it very much

 

[Fluff]

Glad we could help & thanks for the feedback.