Not sure what your trying to do but it would be better to have your dates as
cell references but try this:-

=IF(D3<DATE(2007,12,31),"Expiry",IF(D3<DATE(2008,6 ,30),"Near
Expiry",IF(D3DATE(2008,6,30),"OK","Unspecified")) )

Mike

"Saket" wrote:

Can anyone help me with getting the formula for the following :
If D3<31-12-07 then EXPIRY
IF 30-06-08D3<31-12-07 then NEAR EXPIRY
IF D330-06-08 then OK

Thanx in advance