I don't know whay I can't inculde more than one formula in one cell.

DATA-A DATA-B RESULT

1/31/2010 1/31/2010 Valid
2/2/2008 2/2/2008 Expired
6/6/2010 6/6/2010 Enrolled
(Blank) (Blank) Not Enrolled
N/A N/A N/A

If the date is in the future in Column (B) the result will be [Valid].
If the date is in the past in Column (B) the result will be [Expired].
If the Cell in the Column (A)in Future the result will be [Enrolled]
If the Cell in the Column (A) is Blank, the result will be Blank ("").
If the Cell in the Column (A) is the word (N/A), the result will be [N/A].