I am trying to look for a function that would will display the first of the
month if the cell I am referencing is a date in that month.

For instance: I have a date that says 12/16/09 I want the function/formula
to return 12/1/09.

Is this possible?

I cant seem to find it anywhere.