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