On Thu, 19 Feb 2009 13:43:31 -0500, Ben wrote:

Hi all,

I don't remember the code now, but I came across a quick way to
determine the first and last biz date for a specified month using the
dateserial function.

I don't quite know how to how to get dateserial function to work, can
you share some thoughts/suggestions?

Thanks in advance,

Ben


If you want to use worksheet function, try these

For the first Monday-Friday in the month in cell D1

=DATE(YEAR(D1),MONTH(D1),1+CHOOSE(WEEKDAY(DATE(YEA R(D1),MONTH(D1),1),2),0,0,0,0,0,2,1))

For the last Monday-Friday in the month in cell D1

=DATE(YEAR(D1),MONTH(D1)+1,0-CHOOSE(WEEKDAY(DATE(YEAR(D1),MONTH(D1)+1,0),2),0,0 ,0,0,0,1,2))

Hope this helps / Lars-Åke