Am currently trying to write a custom function for aging of my
invoices which will be used in a macro in my Debtor statement report
- but it's not working as it looks to simple to be good. Can anybody
help thxs.

Function Age(StatementDate, InvDate)
If StatementDate - InvDate <= 30 Then Age = "Current"
If StatementDate - InvDate = 30 Then Age = "30 days"
If StatementDate - InvDate = 60 Then Age = "60 days"
If StatementDate - InvDate = 90 Then Age = "90 days"
If StatementDate = 150 Then Age = "150 days"
End Function

StatementDate & Invdate are in date format.