wanted to use if function by comparing date

[Alok Rai]

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

 

[Mike H]

Tyr:-

=IF(DATE(YEAR(A1),MONTH(A1),DAY(A1))>TODAY(),"After","Before")

Mike

 

[Alok Rai]

Thanks,

i got the solution

Tyr:-

=IF(DATE(YEAR(A1),MONTH(A1),DAY(A1))>TODAY(),"After","Before")

Mike

 

[Teethless mama]

Shorter version

=IF(A1>TODAY(),"After","Before")