Cộng hoặc trừ ngày từ một ngày

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.

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.

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.

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.

Độ chính xác phụ thuộc vào dữ liệu nhập và giả định của phương pháp. Phép tính thập phân dùng 50 chữ số có nghĩa, nhưng ước lượng, phương pháp số và dữ liệu nguồn có thể kém chính xác hơn; làm tròn khi hiển thị không loại bỏ các giới hạn đó. Ví dụ có lời giải đã đối chiếu với nguồn độc lập: 7. Ví dụ, “31 January plus one month in a leap year” được kiểm tra bằng Python dateutil: date(2024,1,31) + relativedelta(months=1) = 2024-02-29 (Excel EDATE agrees).

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