Based on col dates create col of dates for the first day of that same month and year

I have a column of dates say in col B. In col-A i want the following:

ColA ** ColB
1/1/11 ** 1/14/11
1/1/11 ** 1/28/11
2/1/11 ** 2/4/11
1/1/11 ** 1/12/11
3/1/11 ** 3/14/11


Basically, i have a col dates in B.....i want the first day of that month/year in col-A.

I am enclosing a file showing what i want. I can do it in excel but not sure how to "efficiently" do it in vba.

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.

thanks. i will try that. do you know if this is also available via vba code?

thanks.