Calculating Future Date

This post will guide you how to calculate a future date based on a given data in excel. How do I add one or more days to a given date to calculate a future date with a formula in excel. How to calculate a future date excluding weekends in excel. How to calculate a future date excluding weekends and holidays based on a given date with formula in excel.

Calculating Future Date


Assuming that you have a date list in the range of cells B1:B4, and you want to add any number of days (50) into those dates to get a new future new date. You can type this formula into a blank cell in column C.

=B2+50

calculate future date1

Then you need to press enter key in your keyboard, and drag the AutoFill Handler over other cells to apply this formula to add number 50 to get the future dates.

calculate future date2

Calculating Future Date Excluding Weekends


If you want to calculate a new future date excluding weekends, and you need to use the WORKDAY function to create a new formula to exclude all weekends in the future date. So you can write down this formula:

=WORKDAY(B2,50)

#1 Type this formula into the formula box of the cell C2, and then press Enter key in your keyboard.

calculate future date3

#2 go to HOME tab, click Short Date from the General drop down menu list.

calculate future date5

Calculating Future Date Excluding Weekends and Holidays


If you want to calculate a future date excluding weekends and holidays based on a given date, you still need to use the WORKDAY function to create a new formula. At this time, you need to specify which dates are holidays in the certain range of cells (such as: E1:E3).

You can use the following formula to achieve the result:

=WORKDAY(B2,50,$E$1:$E$3)

calculate future date4

Then you can go to HOME tab, click Short Date from the General drop down menu list.so the date can be converted as a short date from a five-digit number.

Related Functions


  • Excel WORKDAY Function
    The Excel WORKDAY function returns a serial number that represents a date that is the indicated number of working days before or after the starting date you specified. The syntax of the WORKDAY function is as below:=WORKDAY(start_date, days, [holidays])…
Related Posts

Sort/Rank Numeric Values with Duplicate Values Exist

Excel built-in RANK function can sort a set of values. If there are duplicate numbers, then the rank number is also duplicated. See the following example: There are two numbers “100” in range A2:A9, they are both the third largest ...

Calculate Days Open in Excel

If you want to know how to Calculate days in Excel, there are some formulas that you can use to do so. For example, you can use the DAYS function in Excel to find the number of days between two ...

Calculate Grades With VLookup in Excel

Why Should You Calculate Grades With VLookup Excel? If you're looking for a simple way to find out a student's grades, VLOOKUP Excel can do the trick. This function uses a lookup table to find the values and sort them ...

Repeating Character n Times in Excel

In daily life, we can use repeated characters to indicate the magnitude or priority of something. For example, a single “!” indicates a minor case, double “!!” indicates a medium case, and triple “!!!” indicates a high case, and so ...

Calculate Cumulative Loan Interest in Excel

What is Cumulative Loan Interest? When comparing different types of loans, many people want to know what is Cumulative Loan Interest. The sum of all interest payments you've made on a loan is referred to as cumulative interest. Different lenders ...

Sidebar