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

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.