On 14 May, 13:24, Joel wrote:
Check to make sure there isn't a single quote in front of the numbers which
would turn them into text. Is the date then 31259 really 3/12/59 ?

"diver_sol" wrote:
On 14 May, 13:01, Joel wrote:
First try formating the cells as date. 31259 when formated aas a date is
7/31/85. It is the number of days since Jan 1, 1900.

"diver_sol" wrote:
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

The cells are formatted as date. Dates are displayed as normal.

To give an example, one cell displays '12th Spetember 2007', in the
forumla bar, the cell has 12/10/2007 but in when used in a logic
statement, the cell has the value 32514 (or something similar)

Which formala should i be using?