DanOfEarth
05-24-2010, 07:48 AM
Real quick,
My brain's not working.
I forgot the simple worksheet function to copy/paste only the MONTH (in TEXT) from one cell to another. ie.
A1: 12/12/2009 B1: December
I thought it was : B1 "=MONTH(A1)"
or.....B1 "=DATE(MONTH(A1))
Guess not.
My brain's not working.
I forgot the simple worksheet function to copy/paste only the MONTH (in TEXT) from one cell to another. ie.
A1: 12/12/2009 B1: December
I thought it was : B1 "=MONTH(A1)"
or.....B1 "=DATE(MONTH(A1))
Guess not.