today | =TODAY() | Thursday, April 17, 2025 |
1 day | =Start_Date+1 | Friday, April 18, 2025 |
7 days | =Start_Date+7 | Thursday, April 24, 2025 |
14 days | =Start_Date+14 | Thursday, May 1, 2025 |
15 days | =Start_Date+15 | Friday, May 2, 2025 |
30 days | =Start_Date+30 | Saturday, May 17, 2025 |
60 days | =Start_Date+60 | Monday, June 16, 2025 |
90 days | =Start_Date+90 | Wednesday, July 16, 2025 |
180 days | =Start_Date+180 | Tuesday, October 14, 2025 |
1 business day | =WORKDAY(Start_Date,1,USHOLIDAYS()) | Friday, April 18, 2025 |
5 business days | =WORKDAY(Start_Date,5,USHOLIDAYS()) | Thursday, April 24, 2025 |
10 business days | =WORKDAY(Start_Date,10,USHOLIDAYS()) | Thursday, May 1, 2025 |
20 business days | =WORKDAY(Start_Date,20,USHOLIDAYS()) | Thursday, May 15, 2025 |
30 business days | =WORKDAY(Start_Date,30,USHOLIDAYS()) | Friday, May 30, 2025 |
1 month | =EDATE(Start_Date,1) | Saturday, May 17, 2025 |
3 months | =EDATE(Start_Date,3) | Thursday, July 17, 2025 |
6 months | =EDATE(Start_Date,6) | Friday, October 17, 2025 |
last business day of this month | =WORKDAY(EOMONTH(Start_Date,0)+1,-1,USHOLIDAYS()) | Wednesday, April 30, 2025 |
last day of this month | =EOMONTH(Start_Date,0) | Wednesday, April 30, 2025 |
1st day of next month | =EOMONTH(Start_Date,0)+1 | Thursday, May 1, 2025 |
1st business day of next month | =WORKDAY(EOMONTH(Start_Date,0),1,USHOLIDAYS()) | Thursday, May 1, 2025 |
plus 1 year | =DATE(YEAR(Start_Date)+1,MONTH(Start_Date),DAY(Start_Date)) | Friday, April 17, 2026 |
plus 2 years | =DATE(YEAR(Start_Date)+2,MONTH(Start_Date),DAY(Start_Date)) | Saturday, April 17, 2027 |
plus 3 years | =DATE(YEAR(Start_Date)+3,MONTH(Start_Date),DAY(Start_Date)) | Monday, April 17, 2028 |
plus 5 years | =DATE(YEAR(Start_Date)+5,MONTH(Start_Date),DAY(Start_Date)) | Wednesday, April 17, 2030 |
plus 10 years | =DATE(YEAR(Start_Date)+10,MONTH(Start_Date),DAY(Start_Date)) | Tuesday, April 17, 2035 |
plus 20 years | =DATE(YEAR(Start_Date)+20,MONTH(Start_Date),DAY(Start_Date)) | Monday, April 17, 2045 |
plus 30 years | =DATE(YEAR(Start_Date)+30,MONTH(Start_Date),DAY(Start_Date)) | Saturday, April 17, 2055 |
1 year end date | =DATE(YEAR(Start_Date)+1,MONTH(Start_Date),DAY(Start_Date)-1) | Thursday, April 16, 2026 |
2 year end date | =DATE(YEAR(Start_Date)+2,MONTH(Start_Date),DAY(Start_Date)-1) | Friday, April 16, 2027 |
3 year end date | =DATE(YEAR(Start_Date)+3,MONTH(Start_Date),DAY(Start_Date)-1) | Sunday, April 16, 2028 |
5 year end date | =DATE(YEAR(Start_Date)+5,MONTH(Start_Date),DAY(Start_Date)-1) | Tuesday, April 16, 2030 |
10 year end date | =DATE(YEAR(Start_Date)+10,MONTH(Start_Date),DAY(Start_Date)-1) | Monday, April 16, 2035 |
20 year end date | =DATE(YEAR(Start_Date)+20,MONTH(Start_Date),DAY(Start_Date)-1) | Sunday, April 16, 2045 |
30 year end date | =DATE(YEAR(Start_Date)+30,MONTH(Start_Date),DAY(Start_Date)-1) | Friday, April 16, 2055 |
30 days before 1 year end date | =DATE(YEAR(Start_Date)+1,MONTH(Start_Date),DAY(Start_Date)-1)-30 | Tuesday, March 17, 2026 |
60 days before 1 year end date | =DATE(YEAR(Start_Date)+1,MONTH(Start_Date),DAY(Start_Date)-1)-60 | Sunday, February 15, 2026 |
90 days before 1 year end date | =DATE(YEAR(Start_Date)+1,MONTH(Start_Date),DAY(Start_Date)-1)-90 | Friday, January 16, 2026 |
30 days before 5 year end date | =DATE(YEAR(Start_Date)+5,MONTH(Start_Date),DAY(Start_Date)-1)-30 | Sunday, March 17, 2030 |
60 days before 5 year end date | =DATE(YEAR(Start_Date)+5,MONTH(Start_Date),DAY(Start_Date)-1)-60 | Friday, February 15, 2030 |
90 days before 5 year end date | =DATE(YEAR(Start_Date)+5,MONTH(Start_Date),DAY(Start_Date)-1)-90 | Wednesday, January 16, 2030 |
30 days before 10 year end date | =DATE(YEAR(Start_Date)+10,MONTH(Start_Date),DAY(Start_Date)-1)-30 | Saturday, March 17, 2035 |
60 days before 10 year end date | =DATE(YEAR(Start_Date)+10,MONTH(Start_Date),DAY(Start_Date)-1)-60 | Thursday, February 15, 2035 |
90 days before 10 year end date | =DATE(YEAR(Start_Date)+10,MONTH(Start_Date),DAY(Start_Date)-1)-90 | Tuesday, January 16, 2035 |