Why do we use ADDDAYS function?
1 Like
The ADDDAYS function is used to increase a given date by a certain number of days. For example, if the input date is 05/06/24, and you want to add 11 days, the function calculates the new date and returns 16/06/24.
Syntax–> ADDDAYS(date, dateFormat, NoOfDays, outPutDateFormat?)
Example–> ADDDAYS(“2024-06-05”, “yyyy-MM-dd”,“11”,“dd/MM/yyyy”)
1 Like