| today | =TODAY() | Saturday, July 27, 2024 |
| 1 day | =Start_Date+1 | Sunday, July 28, 2024 |
| 7 days | =Start_Date+7 | Saturday, August 3, 2024 |
| 14 days | =Start_Date+14 | Saturday, August 10, 2024 |
| 15 days | =Start_Date+15 | Sunday, August 11, 2024 |
| 30 days | =Start_Date+30 | Monday, August 26, 2024 |
| 60 days | =Start_Date+60 | Wednesday, September 25, 2024 |
| 90 days | =Start_Date+90 | Friday, October 25, 2024 |
| 180 days | =Start_Date+180 | Thursday, January 23, 2025 |
| 1 business day | =WORKDAY(Start_Date,1,USHOLIDAYS()) | Monday, July 29, 2024 |
| 5 business days | =WORKDAY(Start_Date,5,USHOLIDAYS()) | Friday, August 2, 2024 |
| 10 business days | =WORKDAY(Start_Date,10,USHOLIDAYS()) | Friday, August 9, 2024 |
| 20 business days | =WORKDAY(Start_Date,20,USHOLIDAYS()) | Friday, August 23, 2024 |
| 30 business days | =WORKDAY(Start_Date,30,USHOLIDAYS()) | Monday, September 9, 2024 |
| 1 month | =EDATE(Start_Date,1) | Tuesday, August 27, 2024 |
| 3 months | =EDATE(Start_Date,3) | Sunday, October 27, 2024 |
| 6 months | =EDATE(Start_Date,6) | Monday, January 27, 2025 |
| last business day of this month | =WORKDAY(EOMONTH(Start_Date,0)+1,-1,USHOLIDAYS()) | Wednesday, July 31, 2024 |
| last day of this month | =EOMONTH(Start_Date,0) | Wednesday, July 31, 2024 |
| 1st day of next month | =EOMONTH(Start_Date,0)+1 | Thursday, August 1, 2024 |
| 1st business day of next month | =WORKDAY(EOMONTH(Start_Date,0),1,USHOLIDAYS()) | Thursday, August 1, 2024 |
| plus 1 year | =DATE(YEAR(Start_Date)+1,MONTH(Start_Date),DAY(Start_Date)) | Sunday, July 27, 2025 |
| plus 2 years | =DATE(YEAR(Start_Date)+2,MONTH(Start_Date),DAY(Start_Date)) | Monday, July 27, 2026 |
| plus 3 years | =DATE(YEAR(Start_Date)+3,MONTH(Start_Date),DAY(Start_Date)) | Tuesday, July 27, 2027 |
| plus 5 years | =DATE(YEAR(Start_Date)+5,MONTH(Start_Date),DAY(Start_Date)) | Friday, July 27, 2029 |
| plus 10 years | =DATE(YEAR(Start_Date)+10,MONTH(Start_Date),DAY(Start_Date)) | Thursday, July 27, 2034 |
| plus 20 years | =DATE(YEAR(Start_Date)+20,MONTH(Start_Date),DAY(Start_Date)) | Wednesday, July 27, 2044 |
| plus 30 years | =DATE(YEAR(Start_Date)+30,MONTH(Start_Date),DAY(Start_Date)) | Monday, July 27, 2054 |
| 1 year end date | =DATE(YEAR(Start_Date)+1,MONTH(Start_Date),DAY(Start_Date)-1) | Saturday, July 26, 2025 |
| 2 year end date | =DATE(YEAR(Start_Date)+2,MONTH(Start_Date),DAY(Start_Date)-1) | Sunday, July 26, 2026 |
| 3 year end date | =DATE(YEAR(Start_Date)+3,MONTH(Start_Date),DAY(Start_Date)-1) | Monday, July 26, 2027 |
| 5 year end date | =DATE(YEAR(Start_Date)+5,MONTH(Start_Date),DAY(Start_Date)-1) | Thursday, July 26, 2029 |
| 10 year end date | =DATE(YEAR(Start_Date)+10,MONTH(Start_Date),DAY(Start_Date)-1) | Wednesday, July 26, 2034 |
| 20 year end date | =DATE(YEAR(Start_Date)+20,MONTH(Start_Date),DAY(Start_Date)-1) | Tuesday, July 26, 2044 |
| 30 year end date | =DATE(YEAR(Start_Date)+30,MONTH(Start_Date),DAY(Start_Date)-1) | Sunday, July 26, 2054 |
| 30 days before 1 year end date | =DATE(YEAR(Start_Date)+1,MONTH(Start_Date),DAY(Start_Date)-1)-30 | Thursday, June 26, 2025 |
| 60 days before 1 year end date | =DATE(YEAR(Start_Date)+1,MONTH(Start_Date),DAY(Start_Date)-1)-60 | Tuesday, May 27, 2025 |
| 90 days before 1 year end date | =DATE(YEAR(Start_Date)+1,MONTH(Start_Date),DAY(Start_Date)-1)-90 | Sunday, April 27, 2025 |
| 30 days before 5 year end date | =DATE(YEAR(Start_Date)+5,MONTH(Start_Date),DAY(Start_Date)-1)-30 | Tuesday, June 26, 2029 |
| 60 days before 5 year end date | =DATE(YEAR(Start_Date)+5,MONTH(Start_Date),DAY(Start_Date)-1)-60 | Sunday, May 27, 2029 |
| 90 days before 5 year end date | =DATE(YEAR(Start_Date)+5,MONTH(Start_Date),DAY(Start_Date)-1)-90 | Friday, April 27, 2029 |
| 30 days before 10 year end date | =DATE(YEAR(Start_Date)+10,MONTH(Start_Date),DAY(Start_Date)-1)-30 | Monday, June 26, 2034 |
| 60 days before 10 year end date | =DATE(YEAR(Start_Date)+10,MONTH(Start_Date),DAY(Start_Date)-1)-60 | Saturday, May 27, 2034 |
| 90 days before 10 year end date | =DATE(YEAR(Start_Date)+10,MONTH(Start_Date),DAY(Start_Date)-1)-90 | Thursday, April 27, 2034 |