Ageing Bucket Formula

[ryan7]

I use the below formula for ageing outstanding transactions; sometimes it returns wrong results though.
Eg it dates transactions dated 31-Jan-2024 as '1-30 days' rather than '31-60 days'. Why?

=IF(F2="U","COA",IF(E2<=EOMONTH(TODAY(),-4),"Over 90 Days",IF(E2<=EOMONTH(TODAY(),-3),"61-90 Days",IF(E2<EOMONTH(TODAY(),-2),"31-60 Days",IF(E2<=EOMONTH(TODAY(),-1),"1-30 Days","Current")))))

 

[dreid1011]

It looks like you're missing the '=' here:

=IF(F2="U","COA",IF(E2<=EOMONTH(TODAY(),-4),"Over 90 Days",IF(E2<=EOMONTH(TODAY(),-3),"61-90 Days",IF(E2<=EOMONTH(TODAY(),-2),"31-60 Days",IF(E2<=EOMONTH(TODAY(),-1),"1-30 Days","Current")))))

 

[Fluff]

Looks like it should be <= rather than < for

IF(E2<EOMONTH(TODAY(),-2)

 

[ryan7]

Looks like it should be <= rather than < for

IF(E2<EOMONTH(TODAY(),-2)

Brilliant, Thank you

 

[Fluff]

Glad we could help & thanks for the feedback.