Start End Date calculation

Hi,

Need a formula that will generate the ending date of task, adding therefore if needed the number of weekend(s) in between the start and end date to the End date.

e.g.:

Let us say: task is starting in 2008/11/11 the duration of the task is 7 days. So, we should get an End Date= 2008/11/19.

2008 11/11 11/12 11/13 11/14 11/15 11/16 11/17 11/18 11/19
Tue Wed Thu Fri Sat Sun Mon Tue Wed

Hi Chamdan,

Try the WORKDAY function, e.g.

If your start date is in H2 (11/11/2008) and your task length is in I2 (7), then in J2 enter:

=WORKDAY(H2,I2-1)

This will return 11/19/2008. (Subtracted 1 from the task length because WORKDAY adds the number of days specified and doesn't include the starting date.)

To use the WORKDAY function, you need to make sure the Analysis Toolpak add-in is loaded.

Hope that helps!

You're welcome, Chuck.

To mark the thread solved, go back to the original post and click the Edit button, then click Go Advanced. Beneath 'Title', select [SOLVED] from the prefix drop-down box and click Save Changes.

Thanks!!