I am trying to use this to automatically add 15 or 5 days to the contract date. The “calculation” field is an IF statement to calculate which amount of days to add. BUT I cannot figure out how to get the formula to add the days and give me a new date.
Notice how the formula you entered was not the one suggested to you. DATEADD() needs to be told the unit of measurement of time to be added. As @Mohamed_Swellam said, you have to tell it to add 'days' to the end.
Hi! I am trying to match the above, but I keep having an issue with the days actually populating correctly - they should be adding from the column Number of Days, which should add the total number of days represented there. Does anyone have any ideas?