Ageing formula

[villival]

Hi Team,

i working on ageing fromuala

i have date and need to find age count i used if today formuale am getting error in applying the formulae and i need to results as 45 days like that depending up on the date

below formulae i used and i attached sample xls.. please help me
=IF(TODAY()-B2<=1;"<24 hours";IF(TODAY()-B2<=7;"2-7 days";IF(TODAY()-B2<=15;"08-15days";IF(TODAY()-B2<=30;"16-30 days";IF(TODAY()-B2<=60;"31-60 days";"over 60 days")))))

 

[azumi]

Hope this works

 

[Charles Otoghile]

This should work:
=IF(INT(TODAY()-B8)<=0,"<24 Hours",
IF(INT(TODAY()-B8)<=7,"2-7 Days",
IF(INT(TODAY()-B8)<=15,"8-15 Days",
IF(INT(TODAY()-B8)<=30,"16-30 Days",
IF(INT(TODAY()-B8)<=60,"31-60 Days",
"Over 60 Days")))))

 

[villival]

This should work:
=IF(INT(TODAY()-B8)<=0,"<24 Hours",
IF(INT(TODAY()-B8)<=7,"2-7 Days",
IF(INT(TODAY()-B8)<=15,"8-15 Days",
IF(INT(TODAY()-B8)<=30,"16-30 Days",
IF(INT(TODAY()-B8)<=60,"31-60 Days",
"Over 60 Days")))))

thanks it works perfectly

 

[bosco_yip]

Or……

C2, formula copy down :

=LOOKUP(NOW()-B2,{0;2;8;16;31;61},{"<24 Hours";"2-7 Days";"8-15 Days";"16-30 Days";"31-60 Days";"Over 60 Days"})

Regards
Bosco