Change dates to the 1st of the Month

**tverdun** · 10-19-2008, 10:13 PM

Hey, I am working in a large database and trying to change the date field. I want to change all the dates to the first of the month.(ie 10/19/2008 to 10/01/2008) Is there a way I can change this in excel without having to go in and manually change all the days to the first. Any help would be extremely appreciated. Thanks

**sglife** · 10-19-2008, 10:20 PM

I think this is what you need

For the date in A1

Please Login or Register  to view this content.

**snasui** · 10-19-2008, 10:25 PM

Assumming your entries are in column A.

B1

Please Login or Register  to view this content.

Hope this helps.

**tverdun** · 10-20-2008, 01:35 AM

Thanks, saved me plenty of work.

**arthurbr** · 10-20-2008, 04:26 AM

Hi,
if this problem is solved for you, please change your thread title to reflect this

**tverdun** · 10-20-2008, 01:10 PM

Sorry, new to this forum.

Change dates to the 1st of the Month

LinkBack

Thread Tools

Rate This Thread

Display

Change dates to the 1st of the Month

Thread Information

Users Browsing this Thread

Similar Threads

B4 to B34 to show the dates within the month selected in the drop down box

Calculate month difference between two dates

Months in Cells - change every month

Month to Month Dates

Drop days from dates to just month and year

Bookmarks

Bookmarks

Posting Permissions