SOLVED

# formula doesn't work

Occasional Contributor

# 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

# Re: formula doesn't work

=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.

# Re: formula doesn't work

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.
best response confirmed by Bn_Rg (Occasional Contributor)
Solution

# Re: formula doesn't work

=DATE(2019,2,15)-DATE(1949,2,15)

You can try this formula. It works in my spreadsheet.

# Re: formula doesn't work

Thank you i fix the problem.