Lookup the month in a date string 01/03/05
 

Hi

I am trying to create an if scenario within a table that lookups a date in
one table (table a) and enters the data into another table (table b) in the
correct monthly columns. I have currently calculated this by showing the date
string as 01/03/05 in table a and within the columns in table b have the
months per column as first day of the month i.e. 01/01/05, 01/02/05 and then
format these to show Jan-05, Feb-05. This works out ok but what I would
prefer is to show in table a the actual date i.e. 14/03/05 but in table b
still have the data within the march column. I am aware there is a formula
that allows a search of the month but I do not know this, can you help?

Many thanks,

Úna

Hi Una,

I am not sure completely understand what you're trying to achieve, but isn't
the following what you'ra after:

if [A1]=14/03/05
then =MONTH(A1) will return 3

Regards,
KL
"Una" wrote in message
...
Hi

I am trying to create an if scenario within a table that lookups a date in
one table (table a) and enters the data into another table (table b) in
the
correct monthly columns. I have currently calculated this by showing the
date
string as 01/03/05 in table a and within the columns in table b have the
months per column as first day of the month i.e. 01/01/05, 01/02/05 and
then
format these to show Jan-05, Feb-05. This works out ok but what I would
prefer is to show in table a the actual date i.e. 14/03/05 but in table b
still have the data within the march column. I am aware there is a formula
that allows a search of the month but I do not know this, can you help?

Many thanks,

Úna