Hi,
If(and(A1=A2,A2<=A3),"X","whatever")
--
Regards,
Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Corca" wrote in message
...
Help.
Cell A1 = 16/1/08
Cell A2 = 1/1/08
Cell A3 = 28/1/08
Formula needed for Cell A4
I would like a formula for:
Cell A4= if A1 =A2 and <=A3 them retuen X
appreciate the help.