# Sumar o restar días a una fecha

> Obtén la fecha un número de días, semanas, meses, años o días laborables antes o después de una fecha inicial, con el día de la semana y los días naturales desplazados.

Versión interactiva: https://www.calcopenly.com/es/datetime/add-subtract-days
Tema: Calculadoras de fecha y hora

Days and weeks are added to the start date's day number, a running count of days since 1 January 1970, so month lengths and leap years take care of themselves. Months and years move the month and keep the day of the month; when that day doesn't exist in the target month, the result is the month's last day, the same rule as Excel's EDATE. Business days are counted one at a time from the day after the start, stepping over the chosen weekend days.

Typical uses are due dates, return and cooling-off windows, visa and licence expiry dates and medication courses. 100 days after 15 January 2026 is Saturday, 25 April 2026, and 5 business days after Friday, 16 January 2026 is the following Friday.

Month steps can't always be undone: 31 March 2026 minus one month is 28 February, and 28 February plus one month is 28 March. Public holidays are not skipped here; the working-day deadline calculator takes a holiday list.

## Datos

- **Start date**
- **Operation** (opciones: Add, Subtract)
- **Amount**
- **Unidad** (opciones: Days, Weeks, Meses, Años, Business days)
- **Weekend** (opciones: Sat–Sun, Fri–Sat, Sun only)

## Resultados

- Resulting date — resultado principal
- Día de la semana
- Calendar days moved (days)
- End-of-month adjustment

## Fórmula

$$
N(\text{result}) = N(\text{start}) \pm n \quad (\text{days}),\qquad \text{day} = \min(d, \text{days in target month}) \quad (\text{months})
$$

## Ejemplos resueltos

### 31 January plus one month in a leap year

- Start date: 2024-01-31
- Operation: Add
- Amount: 1
- Unidad: Meses
- **Resulting date: 2024-02-29**
- **Día de la semana: Thursday**
- **Calendar days moved: 29 days**
- Fuente de comprobación: Python dateutil: date(2024,1,31) + relativedelta(months=1) = 2024-02-29 (Excel EDATE agrees)

### 100 days after 15 Jan 2026

- Start date: 2026-01-15
- Operation: Add
- Amount: 100
- Unidad: Days
- **Resulting date: 2026-04-25**
- **Día de la semana: Saturday**
- Fuente de comprobación: Python 3.8: date(2026,1,15) + timedelta(days=100)

### Leap day plus one year

- Start date: 2024-02-29
- Operation: Add
- Amount: 1
- Unidad: Años
- **Resulting date: 2025-02-28**
- **Calendar days moved: 365 days**
- Fuente de comprobación: Python dateutil: date(2024,2,29) + relativedelta(years=1) = 2025-02-28

### 31 March minus one month

- Start date: 2026-03-31
- Operation: Subtract
- Amount: 1
- Unidad: Meses
- **Resulting date: 2026-02-28**
- **Calendar days moved: -31 days**
- Fuente de comprobación: Python dateutil: date(2026,3,31) − relativedelta(months=1) = 2026-02-28

### Friday plus five business days

- Start date: 2026-01-16
- Operation: Add
- Amount: 5
- Unidad: Business days
- Weekend: Sat–Sun
- **Resulting date: 2026-01-23**
- **Día de la semana: Friday**
- **Calendar days moved: 7 days**
- Fuente de comprobación: numpy.busday_offset('2026-01-16', 5, roll='backward') = 2026-01-23

### Ten business days before 15 Jan 2026

- Start date: 2026-01-15
- Operation: Subtract
- Amount: 10
- Unidad: Business days
- Weekend: Sat–Sun
- **Resulting date: 2026-01-01**
- **Calendar days moved: -14 days**
- Fuente de comprobación: numpy.busday_offset('2026-01-15', -10, roll='forward') = 2026-01-01

## Preguntas

### How do I work out the date 90 days from today?

Enter today as the start date, choose Add, type 90 and pick Days. Counting starts on the day after the start date, so 90 days from 1 January 2026 is 1 April 2026: January, February and March hold 31 + 28 + 31 = 90 days. In a leap year the same count from 1 January ends on 31 March, because February has 29 days.

### What is 31 January plus one month?

28 February, or 29 February in a leap year such as 2024. A day of the month that doesn't exist in the target month is moved back to that month's last day, which is how Excel's EDATE and Python's dateutil relativedelta behave. The same rule makes 31 March minus one month 28 February 2026, and 31 August plus one month 30 September.

### How do I add business days to a date?

Count forward from the day after the start date and skip each weekend day. Friday, 16 January 2026 plus 5 business days is Friday, 23 January, 7 calendar days later; 10 business days before 15 January 2026 is 1 January. Public holidays are not skipped in this calculator, whereas Excel's WORKDAY(start, days, holidays) skips any holidays you list.

### Is adding one year the same as adding 365 days?

Only when the year ahead has no 29 February in it. From 15 January 2027 one year later is 15 January 2028, 365 days on, but from 1 March 2027 one year later is 1 March 2028, 366 days on, because 29 February 2028 falls in between. 29 February 2024 plus one year becomes 28 February 2025 under the month-end rule.

### ¿Qué precisión tiene «Sumar o restar días a una fecha»?

La precisión depende de tus datos y de los supuestos del método. El cálculo decimal usa 50 cifras significativas, pero las estimaciones, los métodos numéricos y los datos de origen pueden ser menos precisos; el redondeo mostrado no elimina esos límites. Ejemplos resueltos comprobados con fuentes independientes: 7. Por ejemplo, «31 January plus one month in a leap year» se comprueba con Python dateutil: date(2024,1,31) + relativedelta(months=1) = 2024-02-29 (Excel EDATE agrees).

### ¿De dónde procede el método?

Howard Hinnant — chrono-compatible low-level date algorithms; Microsoft Excel EDATE and WORKDAY functions (same month-end and business-day conventions).

## Fuentes

- [Howard Hinnant — chrono-compatible low-level date algorithms](https://howardhinnant.github.io/date_algorithms.html)
- [Microsoft Excel EDATE and WORKDAY functions (same month-end and business-day conventions)](https://support.microsoft.com/office/edate-function-3c920eb2-6e66-44e7-a1f5-753ae47ee4f5)