Projecting future date

[jdulac]

I am trying to come up with a formula to automatically project a future date that includes weekends and holidays.

For instance, if A1 = 10/02/2006 (current date, or a past date)

A2 = 60 (or the amount of days)

B1 would show the new date

This would save a lot of time for our staff as they are currently hand counting on a calendar!

Thanks!

[kraljb]

Have a list of Applicable Holidays somewhere... (Sheet2!$A$1:$A$100 for my example

=WORKDAY(A1,A2,Sheet2!$A$1:$A$100)

Hope that helps...

John

[jdulac]

This solution did not work for me. Any other ideas? Again just to reiterate. We have tasks that come in on a certain date. From that certain date we would like to project 60 days out and automatically assign a date when its due.

Thanks!

[oldchippy]

I am trying to come up with a formula to automatically project a future date that includes weekends and holidays.

For instance, if A1 = 10/02/2006 (current date, or a past date)

A2 = 60 (or the amount of days)

B1 would show the new date

This would save a lot of time for our staff as they are currently hand counting on a calendar!

Thanks!

Hi jdulac,

Try this

=A1+A2

oldchippy