Legal Tools / Date Math
‍
VariationFormulaTransformed Date
today=TODAY()Wednesday, June 18, 2025
1 day=Start_Date+1Thursday, June 19, 2025
7 days=Start_Date+7Wednesday, June 25, 2025
14 days=Start_Date+14Wednesday, July 2, 2025
15 days=Start_Date+15Thursday, July 3, 2025
30 days=Start_Date+30Friday, July 18, 2025
60 days=Start_Date+60Sunday, August 17, 2025
90 days=Start_Date+90Tuesday, September 16, 2025
180 days=Start_Date+180Monday, December 15, 2025
1 business day=WORKDAY(Start_Date,1,USHOLIDAYS())Friday, June 20, 2025
5 business days=WORKDAY(Start_Date,5,USHOLIDAYS())Thursday, June 26, 2025
10 business days=WORKDAY(Start_Date,10,USHOLIDAYS())Thursday, July 3, 2025
20 business days=WORKDAY(Start_Date,20,USHOLIDAYS())Friday, July 18, 2025
30 business days=WORKDAY(Start_Date,30,USHOLIDAYS())Friday, August 1, 2025
1 month=EDATE(Start_Date,1)Friday, July 18, 2025
3 months=EDATE(Start_Date,3)Thursday, September 18, 2025
6 months=EDATE(Start_Date,6)Thursday, December 18, 2025
last business day of this month=WORKDAY(EOMONTH(Start_Date,0)+1,-1,USHOLIDAYS())Monday, June 30, 2025
last day of this month=EOMONTH(Start_Date,0)Monday, June 30, 2025
1st day of next month=EOMONTH(Start_Date,0)+1Tuesday, July 1, 2025
1st business day of next month=WORKDAY(EOMONTH(Start_Date,0),1,USHOLIDAYS())Tuesday, July 1, 2025
plus 1 year=DATE(YEAR(Start_Date)+1,MONTH(Start_Date),DAY(Start_Date))Thursday, June 18, 2026
plus 2 years=DATE(YEAR(Start_Date)+2,MONTH(Start_Date),DAY(Start_Date))Friday, June 18, 2027
plus 3 years=DATE(YEAR(Start_Date)+3,MONTH(Start_Date),DAY(Start_Date))Sunday, June 18, 2028
plus 5 years=DATE(YEAR(Start_Date)+5,MONTH(Start_Date),DAY(Start_Date))Tuesday, June 18, 2030
plus 10 years=DATE(YEAR(Start_Date)+10,MONTH(Start_Date),DAY(Start_Date))Monday, June 18, 2035
plus 20 years=DATE(YEAR(Start_Date)+20,MONTH(Start_Date),DAY(Start_Date))Sunday, June 18, 2045
plus 30 years=DATE(YEAR(Start_Date)+30,MONTH(Start_Date),DAY(Start_Date))Friday, June 18, 2055
1 year end date=DATE(YEAR(Start_Date)+1,MONTH(Start_Date),DAY(Start_Date)-1)Wednesday, June 17, 2026
2 year end date=DATE(YEAR(Start_Date)+2,MONTH(Start_Date),DAY(Start_Date)-1)Thursday, June 17, 2027
3 year end date=DATE(YEAR(Start_Date)+3,MONTH(Start_Date),DAY(Start_Date)-1)Saturday, June 17, 2028
5 year end date=DATE(YEAR(Start_Date)+5,MONTH(Start_Date),DAY(Start_Date)-1)Monday, June 17, 2030
10 year end date=DATE(YEAR(Start_Date)+10,MONTH(Start_Date),DAY(Start_Date)-1)Sunday, June 17, 2035
20 year end date=DATE(YEAR(Start_Date)+20,MONTH(Start_Date),DAY(Start_Date)-1)Saturday, June 17, 2045
30 year end date=DATE(YEAR(Start_Date)+30,MONTH(Start_Date),DAY(Start_Date)-1)Thursday, June 17, 2055
30 days before 1 year end date=DATE(YEAR(Start_Date)+1,MONTH(Start_Date),DAY(Start_Date)-1)-30Monday, May 18, 2026
60 days before 1 year end date=DATE(YEAR(Start_Date)+1,MONTH(Start_Date),DAY(Start_Date)-1)-60Saturday, April 18, 2026
90 days before 1 year end date=DATE(YEAR(Start_Date)+1,MONTH(Start_Date),DAY(Start_Date)-1)-90Thursday, March 19, 2026
30 days before 5 year end date=DATE(YEAR(Start_Date)+5,MONTH(Start_Date),DAY(Start_Date)-1)-30Saturday, May 18, 2030
60 days before 5 year end date=DATE(YEAR(Start_Date)+5,MONTH(Start_Date),DAY(Start_Date)-1)-60Thursday, April 18, 2030
90 days before 5 year end date=DATE(YEAR(Start_Date)+5,MONTH(Start_Date),DAY(Start_Date)-1)-90Tuesday, March 19, 2030
30 days before 10 year end date=DATE(YEAR(Start_Date)+10,MONTH(Start_Date),DAY(Start_Date)-1)-30Friday, May 18, 2035
60 days before 10 year end date=DATE(YEAR(Start_Date)+10,MONTH(Start_Date),DAY(Start_Date)-1)-60Wednesday, April 18, 2035
90 days before 10 year end date=DATE(YEAR(Start_Date)+10,MONTH(Start_Date),DAY(Start_Date)-1)-90Monday, March 19, 2035
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.
2025-2026 HolidaysDate
New Year's DayWednesday, January 1, 2025
Martin Luther King Jr. DayMonday, January 20, 2025
President's DayMonday, February 17, 2025
Memorial DayMonday, May 26, 2025
JuneteenthThursday, June 19, 2025
Independence DayFriday, July 4, 2025
Labor DayMonday, September 1, 2025
Columbus DayMonday, October 13, 2025
Veteran's DayTuesday, November 11, 2025
Thanksgiving DayThursday, November 27, 2025
Christmas DayThursday, December 25, 2025
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