Tyr:-

=IF(DATE(YEAR(A1),MONTH(A1),DAY(A1))TODAY(),"Afte r","Before")

Mike

"Alok Rai" wrote:

I am using if formula and wanted to use date as criteria

for eg.

Cell A Cell B

30/01/2006 =if(cell A.............., x,y)
dd/mm/yyyy

I want to use a date in place of ................... Kindly Suggest