Nov 24 2021 12:58 PM
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?
Nov 24 2021 01:09 PM
=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.
Nov 25 2021 02:35 AM
Nov 25 2021 04:46 AM
SolutionNov 25 2021 04:46 AM
Solution=DATE(2019,2,15)-DATE(1949,2,15)
You can try this formula. It works in my spreadsheet.