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

Extract substring In Excel
Extract substring In Excel1

This post will guide you how to use Excel's MID function is a quick and easy way to extract pieces from your text. Use the Excel formula to extract a substring with MID. Note: If you want to extract just ...

How to Use 3D SUM Multiple Worksheets
3D sum multiple worksheets1

To sum a range of numbers is straightforward for most Excel users, but do you know how to establish a 3D reference to total the same range of numerous sheets. In this post, I will present the steps for this ...

Extract all the matches with helper Column
how to extract all matches with helper column1

With Excel's powerful functions IF, INDEX, and MATCH, we can find exactly what you're looking for with a few clicks of the mouse. This step-by-step tutorial will show how easy it is to extract data using these tools and more! ...

If Cell is This Value or That Value

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of logical test. If you want to see if a cell is A or B, and if one of ...

If Value is Greater Than A Certain Value
If Value is Greater Than A Certain Value 1

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the logical test result. If you want to see if a value in one cell is greater than a specific value, ...

If Cell is Not Blank
If Cell is Not Blank 6

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if a cell is blank or not, and leave some ...

If Cell is Blank
If Cell is Blank_1

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if a cell is blank or not, and leave some ...

If Cell Equals Certain Text String
If cell equals certain text_1

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if cell equals a certain text string like “Win”, you ...

If Cell Contains Either Text1 or Text2
If cell contains text1 or text2_1

IF function is frequently used in Excel worksheet to return “true value” or “false value” based on the logical test result. If you want to see if cell contains certain substring1 like “abc” or substring2 like “def”, and returns true ...

If Cell Contains Certain Text OR Equals Certain Text

IF cell equals certain text IF function is frequently used in Excel worksheet to return “true value” or “false value” based on the logical test result. If you want to test values to see if they equal certain text like ...

Sidebar