Hi, in cell B13 I have a date, 04-Jan-2010
I cel A2 I have a formula that looks @ cell A1 and adds 1 month while taking into account weekends and some pre defined busines days.
=WORKDAY(DATE(YEAR($B$13),MONTH($B$13)+ROW(A1),DAY($B$13))-1,1,'Business Holidays'!$A$2:$A$74)
In this case it would yield 04-Jan-2010.
I need to alter this formula in a way that it takes the first day of the month in cell B13 instead of the actuall mentioned date (04-jan-2010).
any ideas???
I cel A2 I have a formula that looks @ cell A1 and adds 1 month while taking into account weekends and some pre defined busines days.
=WORKDAY(DATE(YEAR($B$13),MONTH($B$13)+ROW(A1),DAY($B$13))-1,1,'Business Holidays'!$A$2:$A$74)
In this case it would yield 04-Jan-2010.
I need to alter this formula in a way that it takes the first day of the month in cell B13 instead of the actuall mentioned date (04-jan-2010).
any ideas???