Excel days function Dates does not work

Asked

Viewed 156 times

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 30/01/1900 inserir a descrição da imagem aqui

excel microsoft

  • It gave good, thank you very much. Put as reply !

1 answer

2


Try changing the format of the Date Duration cell to Number, as the number result 30 in Date format are 30 days after the first date that Excel accepts (which is 01/01/1900), so it is day 30/01/1900.

And the dates E2 and F2, in number format are: 42826 and 42856, respectively.

For example, with formatting as number cells look like this:

Número

And as dates, so:

Data

Browser other questions tagged excel microsoft

You are not signed in. Login or sign up in order to post.