date formula
 

Try this formula:
=IF(D1<DATE(2005,4,1),1,IF(D1<DATE(2006,4,1),2,3))

Regards,
Stefi

€ždeepak bsg€� ezt Ã*rta:

i have data with date commissionings of last four years. I want to take them
as, before 01/04/2005 as 1, and in between 01/04/05 to 01/04/2006 as 2 and
after 01/04/2006 as 3. when i'm using datevalue() using if it is satisfying
some conditions only.
can any one help ? I need urgently .