I have data with date of commissionings of three finantial years. I want to
put the numbers instead of dates ex:01/04/2004 to 01/03/2005 (in between
these years) as 1 and 01/04/2005 to 01/03/2006 as 2 and 01/04/2006 up to
current as 3. I have many different dates in between these years, already I
use IF & datevalue functions. but I'm not getting result accurately.
NOTE : There are some d.o.comm are there before 01/04/2004 also they are
also comes under 1 category.
Kindly give any assistiance please as soon as possible.