Convert cell into real date format with a formula in an excel report

When I combine the day and the month to get the full date with the year, excel is not considering as a “date” but as a “text” no matter if I change the format in different ways, the cell stays as “text”. This has no impact in a lot of things but if I want to use this cell to calculate the date, I will not get the correct result. To remediate, I will need to convert the cell with a formula.

formula excel formula excel


When I use the formula ?

To convert the cell in which I combine the day and month into real “date” format.


How to use the formula ?

The formula in this topic is with "," so depending of the operating system of your PC, the formula should have ";" instead of ",".


How are the formula ?







formula excel

NOTE: to display the date, format them to “short date”.

Interesting Management