FIRST day of month formula!!!!!

[buddy1000]

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???

 

[Richard Schollar]

Given a date value in cell B13, the first day of this month can be calculated using:

=B13-DAY(B13)+1