Day function Excel Dates does not work

3

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

    
asked by anonymous 05.10.2017 / 16:54

1 answer

2

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:

    
05.10.2017 / 18:26