If functtion for date
 

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

If functtion for date
 

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

If functtion for date
 

On Dec 17, 6:22 am, 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

Try:

=if(D3<datevalue("31-12-07"), "EXPIRY",
if(D3<datevalue("30-06-08"), "NEAR EXPIRY", "OK")

Note: I am assuming that DATEVALUE() conforms to your country's form
of dates (dd-mm-yy). If not, you might need to conform to DATEVALUE's
form, which is dd-mm-yy in my version. Other forms of date are also
allowed.

If functtion for date
 

Better to use DATE, rather than DATEVALUE, then you don't get the ambiguity
of definition.
--
David Biddulph

"joeu2004" wrote in message
...

Try:

=if(D3<datevalue("31-12-07"), "EXPIRY",
if(D3<datevalue("30-06-08"), "NEAR EXPIRY", "OK")

Note: I am assuming that DATEVALUE() conforms to your country's form
of dates (dd-mm-yy). If not, you might need to conform to DATEVALUE's
form, which is dd-mm-yy in my version. Other forms of date are also
allowed.

On Dec 17, 6:22 am, 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