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”
Amazing website. A lot of useful info here. I’m sending some friends and also share tasty. And, of course, thank you for your hard work!
IT support Dallas