Forum Discussion

Bn_Rg's avatar
Bn_Rg
Copper Contributor
Nov 24, 2021
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...
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Nov 25, 2021

    Bn_Rg 

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

     

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

Bn_Rg's avatar
Bn_Rg
Copper Contributor
Nov 25, 2021
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.
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Nov 25, 2021

Bn_Rg 

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

 

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

  • Bn_Rg's avatar
    Bn_Rg
    Copper Contributor
    Nov 25, 2021
    Thank you i fix the problem.

Resources