D
diver_sol
Hi,
I have a column (e.g. Column X) that lists a series of dates, entered
by the user.
I have a table array (Columns A-L) of all the months, Jan-Dec.
What I want to be able to do is, under each month in the table, look
into Column X and list all the dates within Column X that are relevant
to that month.
I've tried LOOKUP but because dates are formatted like 31259 I dont
know how to write the logic.
Can anyone help?
Thanks a lot
I have a column (e.g. Column X) that lists a series of dates, entered
by the user.
I have a table array (Columns A-L) of all the months, Jan-Dec.
What I want to be able to do is, under each month in the table, look
into Column X and list all the dates within Column X that are relevant
to that month.
I've tried LOOKUP but because dates are formatted like 31259 I dont
know how to write the logic.
Can anyone help?
Thanks a lot