Hi welchs101,

I'm not sure if I undestand, but try this:

In A2 put "=DAY(B2)" --> this will give you the day of the date you have in B2

or

In A2 put "=B2-DAY(B2)+1" --> this will give you the first day of that month you have in B2.

Copy down any of the formulas if works for you.

Hope this helps,

Regards.