I have a column of dates, 10,000 of them, that I need to change from the
entered date covering over 4 years, to dates that all show the 1st day of the
month. Example: Date Entered=10/3/2008 to 10/1/2008 or 9/23/2007 to
9/1/2007. I need to do this so I can use the Pivot Table feature to give me
results based on specific periods of time, such as months and then quarters.
How can I accomplish this?