actually u r wright, just i've changed the format to get the result urgent.
any way thanks for u r cooperation.

"Stefi" wrote:

It should work with any valid Excel date format, either yyyy/mm/dd or
dd/mm/yyyy, etc.
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

"Stefi" wrote:

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:

but when the date is 30/05/2005 it is showing 3. according to criteria it has
to show 2. check once.

"deepak bsg" wrote:

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 .