It is not necessary to check the month:

Put the formula in D1 then change the date in C1 - D1 will give you the first
day of the month if it is a weekday or the first Monday if it is a weekend
day.

edvwvw

cmatera wrote:
But how does that test the month portion of the cell - or would this
be nested in another if statement?

This should get you going in the right direction:

[quoted text clipped - 30 lines]
--
Message posted viahttp://www.officekb.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200808/1