Skip to main content

How to Add Days to a Date in Batch Script

Date arithmetic is one of the most challenging tasks in Batch because the Command Prompt has no built-in date math engine. You must account for varying month lengths, leap years, and year boundaries. The most reliable approach is to convert a date to a serial "Day Number" (like the Julian Day Number), add your desired offset, and convert it back.

In this guide, we will demonstrate how to add days to a date using the Julian Day Number formula via PowerShell for reliability.

PowerShell has a native AddDays() method that handles all edge cases perfectly.

Implementation Script​

@echo off
setlocal

:: Add 30 days to today's date
for /f "usebackq delims=" %%A in (`
    powershell -NoProfile -Command "(Get-Date).AddDays(30).ToString('yyyy-MM-dd')"
`) do set "futureDate=%%A"

echo Today + 30 days = %futureDate%
pause

Adding to a Specific Date​

@echo off
setlocal

set "startDate=2024-02-15"
set "daysToAdd=45"

for /f "usebackq delims=" %%A in (`
    powershell -NoProfile -Command "([datetime]'%startDate%').AddDays(%daysToAdd%).ToString('yyyy-MM-dd')"
`) do set "result=%%A"

echo %startDate% + %daysToAdd% days = %result%
pause
Why PowerShell Is Recommended

PowerShell's [datetime] type natively handles leap years, month boundaries, daylight saving transitions, and calendar edge cases. The AddDays() method also accepts negative values for subtracting days, and decimal values like 1.5 for adding hours alongside days.

Method 2: The Native Batch Approach (Julian Day)​

For environments where PowerShell is unavailable, you can use the Julian Day Number formula. This is significantly more complex but works in pure Batch.

Implementation Script​

@echo off
setlocal enabledelayedexpansion

:: Input Date and Offset
set "y=2024" & set "m=2" & set "d=15"
set "addDays=45"

echo Input: !y!-!m!-!d! + !addDays! days

:: 1. Convert date to Julian Day Number (JDN)
:: Adjust year and month for January/February
set "adjY=!y!"
set "adjM=!m!"
if !adjM! LEQ 2 (
    set /a "adjY=y - 1"
    set /a "adjM=m + 12"
)
set /a "jdn=(1461 * (adjY + 4800)) / 4 + (367 * (adjM - 2)) / 12 - (3 * ((adjY + 4900) / 100)) / 4 + d - 32075"

:: 2. Add the offset
set /a "jdn+=addDays"

:: 3. Convert JDN back to a Calendar Date
set /a "l=jdn + 68569"
set /a "n=4 * l / 146097"
set /a "l=l - (146097 * n + 3) / 4"
set /a "i=4000 * (l + 1) / 1461001"
set /a "l=l - 1461 * i / 4 + 31"
set /a "j=80 * l / 2447"
set /a "d=l - 2447 * j / 80"
set /a "l=j / 11"
set /a "m=j + 2 - 12 * l"
set /a "y=100 * (n - 49) + i + l"

:: 4. Zero-pad month and day
if !m! LSS 10 set "m=0!m!"
if !d! LSS 10 set "d=0!d!"

echo Result: !y!-!m!-!d!
pause
Preserving Input Variables

The JDN conversion requires adjusting the year and month for January and February (subtracting 1 from the year and adding 12 to the month). The original variables y and m must not be modified during this step because they are used in the JDN formula alongside the adjusted values. This script uses separate adjY and adjM variables for the adjustment to keep the original y, m, and d intact for the calculation.

Integer Precision

The JDN formula involves multiplications with large constants like 1461, 4800, and 146097. Intermediate products can approach the 32-bit signed integer limit of 2,147,483,647. The formula is mathematically valid for dates in the common era, but extreme dates far in the future could cause overflow in Batch's set /a arithmetic.

Why Add Days to a Date?​

  1. Expiration Dates: Calculating when a license, certificate, or trial period will expire based on the installation date.
  2. Retention Policies: Determining the cutoff date for deleting files older than "90 days."
  3. Scheduling: Computing the date for a future maintenance window or deadline.

Important Considerations​

Leap Years

The Julian Day formula and PowerShell both handle February 29 correctly. A leap year occurs when the year is divisible by 4, except for century years, which must be divisible by 400. Adding 14 days to 2024-02-15 correctly produces 2024-02-29 (2024 is a leap year), while the same operation on 2023-02-15 produces 2023-03-01.

Month Boundaries

Both methods correctly roll over month boundaries. Adding 15 days to January 25 produces February 9, not "January 40." The JDN approach handles this implicitly through its conversion back to calendar form.

Negative Days

Both methods support negative offsets for subtracting days. In PowerShell, use .AddDays(-30). In the native Batch approach, set addDays to a negative value (e.g., set "addDays=-30"), and the JDN arithmetic handles it correctly.

Conclusion​

Adding days to a date is a critical capability for scheduling and retention scripts.

While the native Julian Day approach proves that it is possible in pure Batch, the PowerShell bridge is the recommended standard for professional use due to its accuracy and simplicity.

By mastering date arithmetic, you ensure your automation can handle time-based logic with the precision needed for compliance, licensing, and maintenance planning.

Table of Contents