Here is the simple set up A1=01/01/2006 I need B1 to be the numeric value for the month so for this case 1. I am dealing with a spreadsheet with 55,000 rows and I need it to transfer down. Please help.
Thanks!
2007-03-13 10:19:00 · 2 answers · asked by Paka 2 in Computers & Internet ➔ Software
b1 should be
=month(a1)
put the $ on a so
=month($a1)
then just doubleclick the little black + bottom corner of the b1 cell when you highlight b1 and it'll copy right down to 55000
Btw you should format the a column to date format first
2007-03-13 10:30:51 · answer #1 · answered by David B 4 · 0⤊ 0⤋
=MONTH(A$1)
EDIT: David's solution will work if you are going across columns. Mine will work if you are going down rows.
If you are going to have different dates in the rows going down, completely leave the $ out and each row will look at the same row column A
2007-03-13 17:30:59 · answer #2 · answered by orlandobillybob 6 · 0⤊ 0⤋