Thread: date formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
deepak bsg[_2_] deepak bsg[_2_] is offline
external usenet poster
 
Posts: 33
Default date formula

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 .