Legal Tools / Date Math
‍
VariationFormulaTransformed Date
today=TODAY()Monday, September 28, 2026
1 day=Start_Date+1Tuesday, September 29, 2026
7 days=Start_Date+7Monday, October 5, 2026
14 days=Start_Date+14Monday, October 12, 2026
15 days=Start_Date+15Tuesday, October 13, 2026
30 days=Start_Date+30Wednesday, October 28, 2026
60 days=Start_Date+60Friday, November 27, 2026
90 days=Start_Date+90Sunday, December 27, 2026
180 days=Start_Date+180Saturday, March 27, 2027
1 business day=WORKDAY(Start_Date,1,USHOLIDAYS())Tuesday, September 29, 2026
5 business days=WORKDAY(Start_Date,5,USHOLIDAYS())Monday, October 5, 2026
10 business days=WORKDAY(Start_Date,10,USHOLIDAYS())Tuesday, October 13, 2026
20 business days=WORKDAY(Start_Date,20,USHOLIDAYS())Tuesday, October 27, 2026
30 business days=WORKDAY(Start_Date,30,USHOLIDAYS())Tuesday, November 10, 2026
1 month=EDATE(Start_Date,1)Wednesday, October 28, 2026
3 months=EDATE(Start_Date,3)Monday, December 28, 2026
6 months=EDATE(Start_Date,6)Sunday, March 28, 2027
last business day of this month=WORKDAY(EOMONTH(Start_Date,0)+1,-1,USHOLIDAYS())Wednesday, September 30, 2026
last day of this month=EOMONTH(Start_Date,0)Wednesday, September 30, 2026
1st day of next month=EOMONTH(Start_Date,0)+1Thursday, October 1, 2026
1st business day of next month=WORKDAY(EOMONTH(Start_Date,0),1,USHOLIDAYS())Thursday, October 1, 2026
plus 1 year=DATE(YEAR(Start_Date)+1,MONTH(Start_Date),DAY(Start_Date))Tuesday, September 28, 2027
plus 2 years=DATE(YEAR(Start_Date)+2,MONTH(Start_Date),DAY(Start_Date))Thursday, September 28, 2028
plus 3 years=DATE(YEAR(Start_Date)+3,MONTH(Start_Date),DAY(Start_Date))Friday, September 28, 2029
plus 5 years=DATE(YEAR(Start_Date)+5,MONTH(Start_Date),DAY(Start_Date))Sunday, September 28, 2031
plus 10 years=DATE(YEAR(Start_Date)+10,MONTH(Start_Date),DAY(Start_Date))Sunday, September 28, 2036
plus 20 years=DATE(YEAR(Start_Date)+20,MONTH(Start_Date),DAY(Start_Date))Friday, September 28, 2046
plus 30 years=DATE(YEAR(Start_Date)+30,MONTH(Start_Date),DAY(Start_Date))Thursday, September 28, 2056
1 year end date=DATE(YEAR(Start_Date)+1,MONTH(Start_Date),DAY(Start_Date)-1)Monday, September 27, 2027
2 year end date=DATE(YEAR(Start_Date)+2,MONTH(Start_Date),DAY(Start_Date)-1)Wednesday, September 27, 2028
3 year end date=DATE(YEAR(Start_Date)+3,MONTH(Start_Date),DAY(Start_Date)-1)Thursday, September 27, 2029
5 year end date=DATE(YEAR(Start_Date)+5,MONTH(Start_Date),DAY(Start_Date)-1)Saturday, September 27, 2031
10 year end date=DATE(YEAR(Start_Date)+10,MONTH(Start_Date),DAY(Start_Date)-1)Saturday, September 27, 2036
20 year end date=DATE(YEAR(Start_Date)+20,MONTH(Start_Date),DAY(Start_Date)-1)Thursday, September 27, 2046
30 year end date=DATE(YEAR(Start_Date)+30,MONTH(Start_Date),DAY(Start_Date)-1)Wednesday, September 27, 2056
30 days before 1 year end date=DATE(YEAR(Start_Date)+1,MONTH(Start_Date),DAY(Start_Date)-1)-30Saturday, August 28, 2027
60 days before 1 year end date=DATE(YEAR(Start_Date)+1,MONTH(Start_Date),DAY(Start_Date)-1)-60Thursday, July 29, 2027
90 days before 1 year end date=DATE(YEAR(Start_Date)+1,MONTH(Start_Date),DAY(Start_Date)-1)-90Tuesday, June 29, 2027
30 days before 5 year end date=DATE(YEAR(Start_Date)+5,MONTH(Start_Date),DAY(Start_Date)-1)-30Thursday, August 28, 2031
60 days before 5 year end date=DATE(YEAR(Start_Date)+5,MONTH(Start_Date),DAY(Start_Date)-1)-60Tuesday, July 29, 2031
90 days before 5 year end date=DATE(YEAR(Start_Date)+5,MONTH(Start_Date),DAY(Start_Date)-1)-90Sunday, June 29, 2031
30 days before 10 year end date=DATE(YEAR(Start_Date)+10,MONTH(Start_Date),DAY(Start_Date)-1)-30Thursday, August 28, 2036
60 days before 10 year end date=DATE(YEAR(Start_Date)+10,MONTH(Start_Date),DAY(Start_Date)-1)-60Tuesday, July 29, 2036
90 days before 10 year end date=DATE(YEAR(Start_Date)+10,MONTH(Start_Date),DAY(Start_Date)-1)-90Sunday, June 29, 2036
You can paste these formulas into fields in AllDrafts to create smart documents with dynamically calculated dates. You can also use them in Excel or Google Sheets; replace Start_Date with a cell reference or name a cell containing a date Start_Date. USHOLIDAYS() is available in AllDrafts, but not in Excel or Google Sheets. You can remove , USHOLIDAYS() from formulas, or replace it with a reference to an array of holiday dates.
Calculated using US Federal Holidays from 01/01/2020 through 12/25/2058.
2026-2027 HolidaysDate
New Year's DayThursday, January 1, 2026
Martin Luther King Jr. DayMonday, January 19, 2026
President's DayMonday, February 16, 2026
Memorial DayMonday, May 25, 2026
JuneteenthFriday, June 19, 2026
Independence Day (observed)Friday, July 3, 2026
Labor DayMonday, September 7, 2026
Columbus DayMonday, October 12, 2026
Veteran's DayWednesday, November 11, 2026
Thanksgiving DayThursday, November 26, 2026
Christmas DayFriday, December 25, 2026
New Year's DayFriday, January 1, 2027
Martin Luther King Jr. DayMonday, January 18, 2027
President's DayMonday, February 15, 2027
Memorial DayMonday, May 31, 2027
Juneteenth (observed)Friday, June 18, 2027
Independence Day (observed)Monday, July 5, 2027
Labor DayMonday, September 6, 2027
Columbus DayMonday, October 11, 2027
Veteran's DayThursday, November 11, 2027
Thanksgiving DayThursday, November 25, 2027
Christmas Day (observed)Friday, December 24, 2027
New Year's Day (observed)Friday, December 31, 2027