42 Weeks From Today

Calculate any Other Combination

Need a different calculation than forty two weeks from today? Use our calculator to find out any past or future date based on your specific requirements. Select the number of days, weeks, or months, and choose whether you want to calculate forward or backward from a specific date.

In 42 Weeks the Average Person Spends...

Calculate in a Spreadsheet or with Code

To calculate a date forty two weeks from today in Excel or Google Sheets, or in different programming languages, use the following formulas and code.

=TODAY() + 294      

// PHP
$futureDate = date('Y-m-d', strtotime('+42 weeks'));
echo $futureDate;

// JavaScript
const futureDate = new Date();
futureDate.setDate(futureDate.getDate() + (42 * 7));
console.log(futureDate.toISOString().split('T')[0]);

# Python
from datetime import datetime, timedelta

future_date = datetime.now() + timedelta(weeks=42)
print(future_date.strftime('%Y-%m-%d'))

// Java
import java.time.LocalDate;

public class DateCalculation {
    public static void main(String[] args) {
        LocalDate futureDate = LocalDate.now().plusWeeks(42);
        System.out.println(futureDate);
    }
}

-- SQL (MySQL)
SELECT DATE_ADD(CURDATE(), INTERVAL 42 WEEK) as future_date;

Each example follows the language's best practices and returns the result in a standard YYYY-MM-DD format. Click the tabs to switch between languages, and use the copy button to copy the code.

Every 42 Weeks from Today

This timeline shows dates in 42-week intervals, from 42 weeks in the past to 336 weeks in the future: