I am trying to set up a spread sheet that will calculate the first of the
month for the start of benefits.

The spread sheet has data is the cell C2 (Hire Date)

For example 12-1-2006 is the start date. I need a formula that will
calculate if C2 = The first of the month, the date returned is the first of
the same month, if C2 is any other date, it will return the first of the
following month.

I also need to take into consideration weekends and holidays.

Thanks for any assitance in advance.