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

 

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 comment