How to format date inside a formula

[alexduy]

Hi,

How do I format a date inside this formula? =CONCATENATE("Today is", "A2")

The date is input into cell A2.

Thanks!

[AlKey]

Try this

=CONCATENATE("The Date is ",TEXT(A2,"m/d/yyyy"))

[cbatrody]

Please change the formula as following:

=CONCATENATE("The Date is ", TEXT(A2,"mm/dd/yyyy"))

[Paul]

You don't need the CONCATENATE function, just the &.

="The date is "&TEXT(A2,"mm/dd/yyyy")

[rcm]

one way...

Please Login or Register  to view this content.

[Paul]

Or how about:

Please Login or Register  to view this content.

[alexduy]

LOL Paul, no need for that crazy formula.

[alexduy]

By the way, thank you all. I love this community.