Many thanks.

--
Your assistance is appreciated.
Griffo



"GRIFFO" wrote:

Is there a way I can add 5 working days AND 6 calendar months to a date in a
one cell function/formula?

basically I want =workday(A1,5,HolidayRange) = result A
resultA + 6 calendar months.


That is I have a date of 21 Feb 2007.
5 working days after this date is 28 Feb 2007 (if there are no holidays).
= 6 calendar months is 28 August 2007.

Can this be done using one cell ? Or do I need two, one for the workday
function, and one for the + 6 calendar month function?


--
Your assistance is appreciated.
Griffo