SOLVED

formula doesn't work

Copper Contributor

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).c1.PNG

What do i have to do for fixing this problem?

4 Replies

@Bn_Rg 

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

@Bn_Rg 

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

 

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

Thank you i fix the problem.
1 best response

Accepted Solutions
best response confirmed by Bn_Rg (Copper Contributor)
Solution

@Bn_Rg 

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

 

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

View solution in original post