Formula to change date value from linked sheet

[Accountstep]

Hello,
Would you tell me how to do this formula, please?
I want to start the formula with the text of CORR DAR, then use a space and link it to another sheet call that has a short date format, then use a space, a dash, and then link it to the same linked sheet cell that has a text value.
e.g. This is the way they have the formula now:

=CONCATENATE("CORR DAR ",ENTRY!A2,"-",ENTRY!B2)

Where the linked sheet name is ENTRY.

The result they're getting in the JE sheet where the formula is is coming out like this:

CORR DAR 44621-715164

We want the result to be CORR DATE 3/1/2022 - 715164.

What is the proper formula, please?

Thank you!

 

[Joe4]

It is important to understand how Excel stores dates. It actually stores them as numbers, specifically the number of days since 1/0/1900 (change any date to General format and you will see it as Excel does). So dates are really just numbers with special date formats in Excell

Also, when using formulas to references other cells, the formulas will only reference the cells values, not any formatting that has been applied to them.
To get the date format you want, you can use the TEXT function, i.e.

=CONCATENATE("CORR DAR ",TEXT(ENTRY!A2,"m/d/yyyy"),"-",TEXT(ENTRY!B2,"m/d/yyyy"))

 

[Accountstep]

Works Beautifully. You're so smart!!

Thanks much!!

 

[Joe4]

Works Beautifully. You're so smart!!

Thanks much!!

You are welcome!

I just use Excel a lot, and have picked up a bunch of things over the years!