Change all dates in a specific date range

I have created macros, but only using the record key. I have not used the vb editor. I need help. I have a date column that has over 60k dates. The dates range from 2003 through 2009. I am trying to assign 1 value to a particular date range. if date is between 06/01/2009 and 06/30/2009, then assign the date as 06/01/2009. Therefore my logic is for the macro to copy the month as is, but change the day to 1 and retain the year as is. The reformatted date is being exported into access. I am working on a deadline, I will take all the help that I can get.

As per forum rules, please adjust your original post thread title to reflect the specific need. This is the programming forum so "macro" is implied, and "help" doesn't follow the rules.

Perhaps "Change all dates in a specific date range"

Then I can give you a few lines of code to take care of it. What column has the dates and what sheetname?

Go to original thread and click EDIT, post #1

You still need to edit the title.
Go to your first post, click [Edit], then [Go Advanced], then you should be able to change it.

Ok, try this macro:

Please Login or Register  to view this content.

Rather than hardcode it to do 6/2009, I made it ask YOU what month you wanted to convert.