Calculated Date Incorrect

Brass Contributor

I have a Date Column that requires the follwoing calculation:

 

=[Task Completed]+[Days To Sign Off]

=[21/10/2022]+[40]

 

It is giving me the date 02/08/1900

 

Can someone explain to me what im doing wrong?

1 Reply

Hello @jamescosten 

 

here are some examples to calculated dates and columns:

https://support.microsoft.com/en-us/office/examples-of-common-formulas-in-lists-d81f5f21-2b4e-45ce-b...

 

Best, Dave