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.
Bookmarks