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.