I am looking to calculate the date 90 days past an identifided date. I know there is an ADDMONTH and ADDYEARS calculation, but not an ADDDAYS, which would have been helpful. Is there another approach to do this?
Example: What is the date 90 days from 11/15/18.
Simply add 90 to the date as in the below:
Let me know if this helps,
Thats simple enough!
You just need to do a '+', i.e.
Date 2 = Date 1 + 90
Then Date 2 will be 90 days after Date 1.
Note the following:
1. Both must have Date format
2. Try to put in a logic to prevent blank dates.