T
tommy
Hi , I have a spread sheet that I use to indicate when a two monthly job
needs doing, a date is put into cell B3 and dates in two monthly gaps are put
into B4 B5 B6 for twelve columns and for ten rows, each row starts with a
different date so they are quite mixed up in the columns , if I name the
columns Jan/Feb/ March and so on, is there any way that I can get all the
dates that are in January to populate the column marked Jan and all the dates
that are in February to populate the Feb column . The dates read ( 12 march
2008 ) with the cell formatted to read that way.
Thanks in advance,
Tommy
needs doing, a date is put into cell B3 and dates in two monthly gaps are put
into B4 B5 B6 for twelve columns and for ten rows, each row starts with a
different date so they are quite mixed up in the columns , if I name the
columns Jan/Feb/ March and so on, is there any way that I can get all the
dates that are in January to populate the column marked Jan and all the dates
that are in February to populate the Feb column . The dates read ( 12 march
2008 ) with the cell formatted to read that way.
Thanks in advance,
Tommy