Dates

[teresa]

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

 

[T. Valko]

If I understand what you want:

=A1=DAY(B1)

Copy down as needed.

 

[teresa]

I can believe the solution was so simple.

Thank you very much!!!!

 

[T. Valko]

You're welcome. Thanks for the feedback!