Add Days Calculator 📅 (Add days to a date) (2024)

Use this days calculator to easily add or subtract days to any given initial date. Add days to date and see what date it will be N days from now, or what date it was N days ago using this day adder. Also shows what day of the week it will be.

Quick navigation:

  1. How to add days to a date
  2. Practical applications of adding days
  3. What day will it be in X days?
  4. History of timekeeping and calendars

This add days calculator is a simple tool you can use when you need to add or subtract days to/from a specific date; or in other words, to see which date it will be after N days have passed, or which date it was N days before any given date. The date format adjusts automatically depending on your browser locale settings.

How to add days to a date

If you wish to find out what date it will be 30 days from now, you just need to write the number '30' in the second field. If the date is different from the current one, let's say Feb 20, 2019, simply write it in the first field. Then click on 'Calculate'. In this case the result would be Mar 22, 2019. Note that the same calculation in the year 2020 will yield Mar 21, 2020 since it is a leap year and February has 29 days.

Despite its name, you can also use the add days calculator to subtract, for example, 90 days from a specific date. First, make sure the right date is entered in the date field and then write '-90' in the second field. If we subtract 90 days from Feb 20, 2019 the result would be Nov 22, 2018.

With both days addition and subtraction, if the time interval is expressed in terms of weeks, months, years, or decades, it is first necessary transform these into a number of days before performing the operation. It is easy to do with weeks (1 week = 7 days), but the other time measures have variable length so the exact number of days will vary depending on the calendar.

Practical applications of adding days

Adding days is useful in many everyday situations. Let's say you ordered custom furniture and you were given a 45-day completion term. With this calculator for adding days, you can easily see when you can expect your furniture to be ready. Just add 45 days to the current date. If the time was given in business days, make sure to use our working days calculator instead!

Another common case when you need to add days is when you want to return a purchase or make use of a guarantee for a given product. Say you have a 14-day free return period and you know you made the purchase on Dec 20, 2017. You enter this date in the date field, then enter 14 in the "days to add" field and the day adder will tell you that you have until end of day on Jan 3, 2018 to return the product.

Add Days Calculator 📅 (Add days to a date) (1)

In another example, maybe you were prescribed medication to take for 10 days, after which you need to visit your GP for evaluation of the treatment. Just enter the date you started taking your medication in the "Date" field and 10 in the "days to add" field of the add days calculator to learn the date after which you should go see your physician again.


What day will it be in X days?

A typical use of a day adder is to check what day of the week it will be in a given number of days. For example, to see what day it will be in 10 days, enter "10" in the "Days to add" field before pressing "Calculate". You see both the resulting date, and the day of the week (Sunday through Monday) it will be. Likewise you can check what day it will be in 5 days, 20 days, or any number of dates.

A trick you can use to get the answer by mental calculation is to check if the number of days to add is wholly divisible by seven. If it is, then it will be exactly the same day of the week. For example, if the question is "what day will it be in 7 days" and it is Tuesday today, it will be Tuesday in seven days as well. Likewise it will be Tuesday in 14, 21, or 28 days.

History of timekeeping and calendars

Knowing the calendar is crucial for adding days correctly. A calendar is a timekeeping system which is made for civil, religious, or administrative purposes. Calendars are usually based on astronomical events, such as the movement of the Earth and the Moon. The word calendar could also be used as a reference to a device, usually paper, which shows the dates in a particular period of time; or to a time table for events, such as cultural ones.

Methods for timekeeping have existed as far back as the Neolithic period; thousands of years BC [1]. For obvious reasons the day is the most natural unit to use: one of the most obvious things for human beings is that there is darkness and brightness at about equal periods of time, which affect the way we live, sleep, eat, etc. Other than the day, there is obviously the solar year which dictates the seasons; from a human standpoint, this is important for growing and finding food, and overall surviving. Last but not least, there are the lunar phases; they are quite obvious for the naked eye and are of great importance in some religions and in many myths.

Different calendars warrant a different way to add days to a given date. Solar calendars are one of the two main kinds. The first solar calendar is likely the Egyptian, which might have been developed as early as 4000 BC. A solar calendar is based on the change in the position of planet Earth in regards to the Sun. In a solar calendar one year represents one complete rotation of Earth around the Sun. There are two types of solar calendars: Tropical and Sidereal.

The Gregorian calendar, which is currently the most widely used calendar in the world, is solar, thus, it is not related to the moon cycles. The mean length of its year is 365.25 days. To make it dividable into days we accept that three years in a row will have 365 days and the forth one, also called leap year, will have 366 days with one more day added to February. This is the calendar used in our calculator.

Lunar calendars are based on the movement of the Moon around the Earth. They use the lunar month, also called a lunation. This is the period between two new moons, equal to about 29.5 days. A month in a lunar calendar is either 29 or 30 days, as opposed to solar months which range between 28 and 31 days. The brightest example of such calendar would the Islamic, currently the official one in Saudi Arabia and other countries.

The Islamic calendar does not correspond to the movement of the Sun and thus the change in seasons, which can make it quite difficult to work with if you are in agriculture. Because the lunar year is about 11 days shorter than the solar, there are big changes in when the start of January would be in relation to the seasons: one year it might be in the middle of the winter and some years later it will be in the middle of the summer. Thus, you never know on what date a certain holiday or religious celebration would be. Most calendars that have their months base on the moon cycles are actually lunisolar (or solilunar). Lunar calendars are not supported for our calculator.

Lunisolar calendars are a combination of the lunar and the solar. Such is the Jewish calendar, which is based on both the lunar cycles and the solar year. In it the beginning of the month will always be the new moon. However, every few years it adds a leap month in order to correct for seasonal changes.

Currently, our add days to date calculator only supports the internationally recognized calendar and does not support these more esoteric ones, but let us know if that is something you would like to see us do!

References

1 "History of calendars". [online] Available at: https://en.wikipedia.org/wiki/History_of_calendars

Add Days Calculator 📅 (Add days to a date) (2024)

FAQs

How do you create a formula that adds days to a date? ›

To add a number of days to a date, or to subtract a number of days from a date, just add or subtract the number of days. You don't need any special functions. “=A1+10” returns December 25, 2014, which is ten days after December 15.

How do I add 30 days to a date? ›

To calculate the date, which is 30 days from today, you can follow these steps:
  1. Take today's date or any other initial date.
  2. Add 30 days to the determined date.
  3. That's it! You have successfully calculated the date, 30 days from now.
Jan 18, 2024

How do you calculate the number of days from a date? ›

How do I go about calculating the days between two dates? To calculate the number of days between two dates, you need to subtract the start date from the end date. If this crosses several years, you should calculate the number of full years. For the period left over, work out the number of months.

How do I add 14 days to a date in Excel? ›

For date values, you can simply use arithmetic with day value to get new date. So if cell A1 has your date, then you can use =A1+14 to get 14 days after the date.

What is the formula for dates to days? ›

The DAYS function in Excel is a formula designed to compute the count of days between two given dates. The syntax for the function is “=DAYS(end_date, start_date).” Therefore, the end date is specified as the first argument in the formula, and the start date is specified as the second argument in the formula.

What is the formula to add working days to a date in Excel? ›

Open Excel and select the cell where you would like the result to be displayed. Enter the formula “=WORKDAY(start_date, num_days)” in the selected cell. Replace “start_date” with the desired starting date and “num_days” with the number of days to add or subtract. Press Enter to calculate the result.

How do you add days to a current date? ›

Using setDate() Method

First, you create a Date object representing the current date. Then, you can add days to this current date and assign the result to a new date object. This method is useful for manipulating dates in JavaScript.

How to do a date plus 30 days in Excel? ›

In cell C1, type =A1+30, and then press RETURN . This formula adds 30 days to the date in cell A1.

How do I add 30 days to a date in Word? ›

For example, you might type txtAdd30Days. Click Insert Function in the Insert Formula dialog box. Under Categories in the Insert function dialog box, click Date and Time, and then under Functions, click addDays. Click OK.

How do you calculate days quickly? ›

To count days:
  1. Assign each day of the week a value between 1 and 7.
  2. If your days occur within the same week, subtract the earlier date from the later date.
  3. If your days occur in different weeks, add 7 to the later date for each week of difference, and then do the same subtraction.
Jan 18, 2024

What is the easiest way to calculate day from date? ›

Calculate What Day of the Week it is With Our Simple Formula
  1. Take the last two digits of the year.
  2. Add to that one–quarter of those two digits (discard any remainder).
  3. Add to that the day of the month and the Month Key number for that month: Read Next. ...
  4. Divide the sum by 7. The remainder is the day of the week!
May 6, 2024

What is the formula for adding days to a date? ›

For example: Adding days to a date: =DATE(2015, 5, 20) + 15 The formula adds 15 days to May 20, 2015 and returns June 4, 2015. Subtracting days from a date: =DATE(2015, 5, 20) - 15 The result of the above formula is May 5, 2015, which is May 20, 2015 minus 15 days.

How do you add 7 days to a date in Excel? ›

By adding the desired number of days to the initial date using the DATE function, you can obtain the incremented date. For example, by using =A1+7, where A1 contains the initial date, you can increment the date by 7 days.

How do I automatically calculate days between dates in Excel? ›

To find the number of days between these two dates, you can enter “=B2-B1” (without the quotes into cell B3). Once you hit enter, Excel will automatically calculate the number of days between the two dates entered. Note that Excel recognizes leap years.

How do I automatically insert dates and days in Excel? ›

Ctrl + ; shortcut inserts the today date in a cell. Ctrl + Shift + ; shortcut inserts the current time. To enter the current date and time, press Ctrl + ; then press the Space key, and then Ctrl + Shift + ;.

What is the DateAdd function in Excel? ›

You can use the DateAdd function to add or subtract a specified time interval from a date. For example, you can use DateAdd to calculate a date 30 days from today or a time 45 minutes from now. To add days to date, you can use Day of Year ("y"), Day ("d"), or Weekday ("w").

Is there a day formula in Excel? ›

Excel DAY function

DAY(serial_number) function returns a day of the month as an integer from 1 to 31. Serial_number is the date corresponding to the day you are trying to get. It can be a cell reference, a date entered by using the DATE function, or returned by other formulas.

References

Top Articles
Latest Posts
Article information

Author: Ouida Strosin DO

Last Updated:

Views: 6285

Rating: 4.6 / 5 (56 voted)

Reviews: 95% of readers found this page helpful

Author information

Name: Ouida Strosin DO

Birthday: 1995-04-27

Address: Suite 927 930 Kilback Radial, Candidaville, TN 87795

Phone: +8561498978366

Job: Legacy Manufacturing Specialist

Hobby: Singing, Mountain biking, Water sports, Water sports, Taxidermy, Polo, Pet

Introduction: My name is Ouida Strosin DO, I am a precious, combative, spotless, modern, spotless, beautiful, precious person who loves writing and wants to share my knowledge and understanding with you.