On 14 May, 13:56, Joel wrote:
Always use the date. For example
=(A1 4/5/07,TRUE,FALSE)

When you debug a formula with a date it will show up as the 31259. Excel
treats dates justt like number, except it will display the date on the
worksheet when the cells arre formated as dates.

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

Thanks,

So, if i want to say, under the january column, 'display all the dates
in january from Column X', how would I write the statement?