Excel does not recognize dates because they are not formatted perfectly. Hereinafter, we have mentioned all the methods by which you can format the date. Once you do that, there won’t be any issues.

Excel does not recognize this conversion and simply displays "50," which can cause problems in other calculations. ... do not multiply this number by 100, because Excel does that automatically.