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 after Sunday, January 31, 2027 is Sunday, February 28, 2027

  • The two dates are 28 days apart.
  • There is no February 31, 2027, so February 28 is used instead.
  • It is day 59 of 2027, in week 10.
  • It is 117 days from today.

On the calendar

January 2027
SuMoTuWeThFrSa
12
3456789
10111213141516
17181920212223
24252627282930
31
February 2027
SuMoTuWeThFrSa
123456
78910111213
14151617181920
21222324252627
28
  • Sunday, January 31, 2027: the start date, not counted
  • Sunday, February 28, 2027: 28 days, 19 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.