Excel Magic – When inserting the cell value of a date into a formula, the date converts into a numeric value and doesn’t display in a date format correctly

Scenario:  In Cell A1 you have a date of ‘6/3/2016’.  In Cell B1, you have a formula that pulls in the date:

=”Today is “&A1

Instead of getting the value  Today is 6/3/2016, you get Today is 41428

 

Solution:  Use the Text function inside your fomula to convert the date from numeric form to date form.

=”Today is “& TEXT(A1,”M/D/YYYY”)

Today is 6/3/2016

 

Advertisement

One thought on “Excel Magic – When inserting the cell value of a date into a formula, the date converts into a numeric value and doesn’t display in a date format correctly”

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

%d bloggers like this: