date calculation issues
 

I need a formula that will calculate future dates for me. If I were to insert
todays date,(as an example) 13-june-2005 into excel, I need it to calculate 6
weeks, 6 months, 1 year, 2 years, 3 years and 4 years ahead of the date
specified. On top of this, the future dates cannot land on a weekend or a
holiday. I am aware of the WORKDAY function but don't know how to use it. My
excel experience with formula's is limited. Very basic steps is required.

On Mon, 13 Jun 2005 10:21:02 -0700, mike richard <mike
wrote:

I need a formula that will calculate future dates for me. If I were to insert
todays date,(as an example) 13-june-2005 into excel, I need it to calculate 6
weeks, 6 months, 1 year, 2 years, 3 years and 4 years ahead of the date
specified. On top of this, the future dates cannot land on a weekend or a
holiday. I am aware of the WORKDAY function but don't know how to use it. My
excel experience with formula's is limited. Very basic steps is required.

See answer in misc group.

There is no need to multipost.


--ron