# How to calculate "End Date" with the input of Start Date & No. of days

#### theambarish

##### New Member
Hi Gurus,

Formula to calculate "End Date" with the input of Start Date & No. of days?
Note - only week days are to be considered.
For example

Start Date No of Days End Date Notes
A B C

#1 27/3/2009 4 ??? Ignore weekends
Ignore holiday of 28/3/2009

### Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Have a look at the workday() function

or NETWORKDAYS function.

I think that Networkdays, calculates the number of days between 2 dates, which isnt what the OP was after

I think that Networkdays, calculates the number of days between 2 dates, which isnt what the OP was after

holy crap I just figured out what that is

network days
and i've never understood why the function has that name

net workdays
duh !

I think that Networkdays, calculates the number of days between 2 dates, which isnt what the OP was after

Sorry. you are right.

Replies
4
Views
132
Replies
11
Views
468
Replies
1
Views
453
Replies
3
Views
82
Replies
9
Views
272

1,211,888
Messages
6,104,587
Members
447,917
Latest member
cbacba

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back