SyntaxFix
Write A Post
Hire A Developer
Questions
=TO_DATE(TO_PURE_NUMBER(Insert Date cell, i.e. AM4)+[how many days to add in numbers, e.g. 3 days])
=TO_DATE(TO_PURE_NUMBER(Insert Date cell, i.e. AM4)
Looks like in practice:
=TO_DATE(TO_PURE_NUMBER(AM4)+3)
Essentially you are converting the date into a pure number and back into a date again.