Forum Discussion
Solved
formula doesn't work
i would like to calculate the number of days between February 15, 1949, and Febrruary 15, 2019, and i type in a cell the following formula: ="2/15/19"-"2/15/49" but every time it appear me the mess...
=DATE(49,2,15)-DATE(19,2,15)
You can enter above formula. However i would enter the dates in two other cells and calculate the difference as shown in attached file.
hi, thanks for answering me, unfortunately with the formula I wrote in my question, it should find the number of days between February 15, 1949 and February 15, 2019. The result must be 25567 days.
- Thank you i fix the problem.