I do not know what to do, excel does not show me the correct result in the date formula below, the expected result should be 30 days but appears 1/30/1900
Try to change the format of the Date to Number cell because the result of number 30
in Date format is 30 days after the first date that Excel accepts (which is 01/01/1900) It is day 30/01/1900
.
And dates E2
and F2
, in number format are: 42826
and 42856
, respectively.
For example, with the formatting as number cells look like this:
Andlikedates,likethis: