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 .
|