How can i compare dates?

hi all,

I want to compare dates in a If statement:

The logic is :

E.g:

If(date1=date2,positive action,negative action)

Can you give more details. maybe an example

Mangesh

like how to compare 2 dates:

date in A1 cell=2/2/2005
date in B1 cell=2/2/2005

can i compare them this way:

If a1=b1

Yes, you can.
=If(a1=b1,"match","no match")

or if you want to check if it matches todays date, then
=If(a1=TODAY(),"match","no match")

or some arbitrary date like 15 april 2005
=If(a1=DATE(2005,4,15),"match","no match")


- Mangesh

Thanks a lot....