Enter a start date and how many days, weeks, months or years to add or subtract. Days alone are also counted in working days.

Result

1 month and 1 day after Saturday, January 30, 2027 is Monday, March 1, 2027

  • The two dates are 30 days apart.
  • There is no February 30, 2027, so February 28 is used instead, and the days are counted from it.
  • It is day 60 of 2027, in week 10.
  • It is 118 days from today.

On the calendar

January 2027
SuMoTuWeThFrSa
12
3456789
10111213141516
17181920212223
24252627282930
31
February 2027
SuMoTuWeThFrSa
123456
78910111213
14151617181920
21222324252627
28
March 2027
SuMoTuWeThFrSa
123456
78910111213
14151617181920
21222324252627
28293031
  • Saturday, January 30, 2027: the start date, not counted
  • Monday, March 1, 2027: 30 days, 20 working days
  • Days counted
  • Federal holidays (United States)

How it counts

  • The start date is not counted, so 1 day after a Friday is the Saturday.
  • Years and months are added first, then weeks and days, and a week is always 7 days. When the month is too short for the day, its last day is used: 1 month after January 31, 2027 is February 28, 2027, and 1 month and 1 day after January 30, 2027 is March 1, 2027.
  • When only days are added or subtracted, up to 1,096 (3 years), they are also counted in working days. As with the WORKDAY function of spreadsheets, that day is always a working day: 1 working day after Friday, July 2, 2027 is Tuesday, July 6, as Independence Day is observed on Monday, July 5.
  • Working days are the weekdays other than the holidays of the region you choose (federal holidays in the United States, bank holidays in England and Wales, federal statutory holidays in Canada or public holidays in New South Wales, Australia) and the weekdays they are observed on. They are counted from 1900 to 2100 (from 2011 in Australia).
  • Dates are in the Gregorian calendar, so results before Friday, October 15, 1582, when it began, are out of range.