Re-set a date to the first of the month

  • Thread starter Thread starter OS
  • Start date Start date
O

OS

Hello,

I need to re-set whatever date is entered in a cell to the first of
that month. For example if someone enters 9/11/2008, I need it to be
re-set to 9/1/2008.
Is this possible, and if so, can you please tell me how to do it??

thanks in advance!
 
You could use a formula in another cell:
=date(year(a1),month(a1),1)
or
=a1-day(a1)+1

Then copy|paste special|values over the original range (a column???)
 
You could use a formula in another cell:
=date(year(a1),month(a1),1)
or
=a1-day(a1)+1

Then copy|paste special|values over the original range (a column???)
Click to expand...

Hi Dave,

Both ways worked!! Thank you!
 
Back
Top