Dates
 

Hello

I need to compare a number in one cell to a date in another to see if they
match (I am matching the day in the date).
A B
15 02/15/09 =true
23 01/23/09 =true
1 05/11/08 =false
3 02/30/09 =false

Can this be done?

Thanks.......

30 01/30/09
15 02/15/09
1 02/01/09

Dates
 

If I understand what you want:

=A1=DAY(B1)

Copy down as needed.

--
Biff
Microsoft Excel MVP


"teresa" wrote in message
...
Hello

I need to compare a number in one cell to a date in another to see if they
match (I am matching the day in the date).
A B
15 02/15/09 =true
23 01/23/09 =true
1 05/11/08 =false
3 02/30/09 =false

Can this be done?

Thanks.......

30 01/30/09
15 02/15/09
1 02/01/09

Dates
 

I can believe the solution was so simple.

Thank you very much!!!!

"T. Valko" wrote:

If I understand what you want:

=A1=DAY(B1)

Copy down as needed.

--
Biff
Microsoft Excel MVP


"teresa" wrote in message
...
Hello

I need to compare a number in one cell to a date in another to see if they
match (I am matching the day in the date).
A B
15 02/15/09 =true
23 01/23/09 =true
1 05/11/08 =false
3 02/30/09 =false

Can this be done?

Thanks.......

30 01/30/09
15 02/15/09
1 02/01/09

Dates
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"teresa" wrote in message
...
I can believe the solution was so simple.

Thank you very much!!!!

"T. Valko" wrote:

If I understand what you want:

=A1=DAY(B1)

Copy down as needed.

--
Biff
Microsoft Excel MVP


"teresa" wrote in message
...
Hello

I need to compare a number in one cell to a date in another to see if
they
match (I am matching the day in the date).
A B
15 02/15/09 =true
23 01/23/09 =true
1 05/11/08 =false
3 02/30/09 =false

Can this be done?

Thanks.......

30 01/30/09
15 02/15/09
1 02/01/09