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 message #VALUE (see the screenshot).
What do i have to do for fixing this problem?
4 Replies
=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.
