Hi Claudia, The formula you have used is incorrect. If you would like to add 12 days to a given date, please use the add function. The add function can be used to add seconds, minutes, hours, days, months or years to a date or date & time question.
Syntax:
inputdate.add(number, term)
where
- number: a number value that must be added to the date or date & time
- term: determines whether to add seconds, minutes, hours, days, months or years
- inputdate: the date to consider in the calculation. This can be date or date & time question or a formula that returns a date or date & time.
Example usage:
TODAY().add(3,"days")
TODAY().add(6,"months")
TODAY().add(2,"years")
NOW().add(3,"hours")
NOW().add(25,"minutes")
NOW().add(10,"seconds")
Comments (1)
Sep 23, 2025
Hi Claudia, The formula you have used is incorrect. If you would like to add 12 days to a given date, please use the add function. The add function can be used to add seconds, minutes, hours, days, months or years to a date or date & time question. Syntax: inputdate.add(number, term) where - number: a number value that must be added to the date or date & time - term: determines whether to add seconds, minutes, hours, days, months or years - inputdate: the date to consider in the calculation. This can be date or date & time question or a formula that returns a date or date & time. Example usage: TODAY().add(3,"days") TODAY().add(6,"months") TODAY().add(2,"years") NOW().add(3,"hours") NOW().add(25,"minutes") NOW().add(10,"seconds")
Add your comment
Add photo