date formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 .
 
I've checked and for me the formula returns 2 for 30/05/2005. Have a look at
the cell containing 30/05/2005! Is it a real Excel date?

Stefi

„deepak bsg†ezt írta:
 
Thank u stefi
I've checked my data (it's purely excel ) & I changed the date format to
yyyy/mm/dd.
When changed it into that format the formula is getting the result.
so thank u very much
 
but when the date is 30/05/2005 it is showing 3. according to criteria it has
to show 2. check once.
 
It should work with any valid Excel date format, either yyyy/mm/dd or
dd/mm/yyyy, etc.
Stefi


„deepak bsg†ezt írta:
 
Back
Top