Formatting a date inside a formula

[Stevethetaxman]

Cell A1: 6/2/2011

Cell A2: ="Today's Date is "&A1

How do I get A2 to show: Today's date is 6/2/2011 and not Today's Date is 40696?

Thanks in advance.

 

[T. Valko]

Cell A1: 6/2/2011

Cell A2: ="Today's Date is "&A1

How do I get A2 to show: Today's date is 6/2/2011 and not Today's Date is 40696?

Thanks in advance.

Try it like this...

="Today's Date is "&TEXT(A1,"m/d/yyyy")

Or:

="Today's Date is "&TEXT(NOW(),"m/d/yyyy")

 

[Stevethetaxman]

Perfect. Thanks.

 

[Desu Nota from Columbus]

Cell A1: 6/2/2011

Cell A2: ="Today's Date is "&A1

How do I get A2 to show: Today's date is 6/2/2011 and not Today's Date is 40696?

Thanks in advance.

=CONCATENATE("Today's Date is ",TEXT(A1,"mm/dd/yyyy"))

or

=Concatenate("Today's Date is ", TEXT(Today(), "mm/dd/yyyy"))




I didn't refresh the thread before posting so this is a little late... I like using concatenate instead of the ampersand. Concatenate is such an imperative sounding word!

 

[T. Valko]

Perfect. Thanks.

You're welcome. Thanks for the feedback!