hi frends,
i have 1 simple questions, if i want to sorting emp age, than i will used dated if formula
for example in cell Date of Birth A1 = 01-dec-84 B1= =DATEDIF(A1,TODAY(),"y") than sorted out.
what shud i do if i have to sorting exp for example
in cell Date of joining A1 = 01-sep-09 in cell B1 =TODAY()-A1 result 00/07 formatted cell custom : type yy/mm
Now how would i sorting now bcoz there is hundreds row when i sorted all rows gone
i have to sorting less than 10 yrs 10/01, then greater than 15/00
can anyone help me out from this problem
thanx
Bookmarks