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

=DATE(YEAR(WORKDAY(A1,5,Holidays)),MONTH(WORKDAY(A 1,5,Holidays))+6,DAY(WORKDAY(A1,5,Holidays)))



--

Regards,

Peo Sjoblom





"GRIFFO" wrote in message
...
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

Hi Griffo,

I am not clear on whether you want the entire formula in one cell with the
date embedded in the formula or whetrer you have a date in another cell and
want to use that date so here is both methods.

21 Feb 2007 in cell A1:-
=DATE(YEAR(WORKDAY(A1,5)),MONTH(WORKDAY(A1,5))+6,D AY(WORKDAY(A1,5)))

21 Feb 2007 embedded in the formula:-



"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

Hi again Griffo,

Something went wrong half way through my previous reply so here it is again:-

I am not clear on whether you want the entire formula in one cell with the
date embedded in the formula or whether you have a date in another cell and
want to use that date so here is both methods.

21 Feb 2007 in cell A1:-
=DATE(YEAR(WORKDAY(A1,5)),MONTH(WORKDAY(A1,5))+6,D AY(WORKDAY(A1,5)))

21 Feb 2007 embedded in the formula:-

=DATE(YEAR(WORKDAY("21 Feb 2007",5)),MONTH(WORKDAY("21 Feb
2007",5))+6,DAY(WORKDAY("21 Feb 2007",5)))

Note that these should be one line.

Regards,

OssieMac




"OssieMac" wrote:

Hi Griffo,

I am not clear on whether you want the entire formula in one cell with the
date embedded in the formula or whetrer you have a date in another cell and
want to use that date so here is both methods.

21 Feb 2007 in cell A1:-
=DATE(YEAR(WORKDAY(A1,5)),MONTH(WORKDAY(A1,5))+6,D AY(WORKDAY(A1,5)))

21 Feb 2007 embedded in the formula:-



"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

6 months after your result A is =DATE(YEAR(A),MONTH(A)+6,DAY(A)), and hence:
=DATE(YEAR(workday(A1,5,HolidayRange)),MONTH(workd ay(A1,5,HolidayRange))+6,DAY(workday(A1,5,HolidayR ange)))
Usual questions apply, such as what date you regard 6 months after 30th
August.
--
David Biddulph

"GRIFFO" wrote in message
...
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

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