Free Date Calculator - Days Between Dates & More

Date calculations are essential for project planning, deadline tracking, and scheduling. Our free date calculator handles all common date scenarios in Google Sheets.

What Is This Tool?

A date calculator that computes days between dates, adds/subtracts days from a date, counts workdays, and calculates deadlines. Google Sheets stores dates as serial numbers, making date math straightforward.

Formula: =B1-A1 gives days between dates. =A1+30 adds 30 days to a date. =NETWORKDAYS(A1,B1) counts weekdays only. =WORKDAY(A1,10) finds a date 10 workdays away.

How to Use

Calculate Days Between Two Dates

Enter a start date and end date. The calculator returns the number of days between them.

Add or Subtract Days from a Date

Enter a start date and the number of days to add (or subtract with a negative number). The new date is calculated instantly.

💡 Use this for deadlines, follow-ups, and expiration dates.

Count Workdays Only

The calculator can exclude weekends and even custom holidays. This helps with realistic project deadline planning.

Find a Future Date by Workdays

Enter a start date and the number of workdays to find the exact end date. Useful for project planning with business days only.

Benefits

✓Instant days-between-dates calculation

✓Workday (business day) calculations

✓Holiday exclusions for accurate planning

✓Deadline and due date tracking

✓Project timeline planning made easy

Frequently Asked Questions

How do I calculate days between dates in Google Sheets?

Simply subtract the earlier date from the later date: =B1-A1. Format the result as a number.

How do I count only weekdays?

Use =NETWORKDAYS(start_date, end_date) to count Monday-Friday only. Add a holiday range as a third parameter.

How do I find the date after N workdays?

Use =WORKDAY(start_date, num_days). Add a holiday range as a third parameter to exclude holidays.

Related Templates

Project Timeline Template Content Calendar Template