aging

=IF(TODAY()-F2<=30,"0-30 days",IF(TODAY()-F2<=60,"31-60 days",IF(TODAY()-F2<=90,"61-90 days","over 90 days"))) The formula above works great for aging a report I have based on today's date of 7/9/2014. However the report was prepared on 7/1/2014, so I need to age based on 7/1/2014. How can I...

Dear All, I am looking for a formula that will calculate aging buckets for transactions. How do you translate the number of days into age groups such as: 0-30, 31-60, 61-90, 91-120, and >120. Once you have that figured out, let's push the limits. How about groups like: 0-30, 31-60, 61-90...

Hi All, I am looking for a formula to put into my access 2007 query screen to be able to recreate an aging report to show only open invoices. EXAMPLE: CUST # CUST NAME DOC TYPE APPLY TO NO TOTAL AMOUNT 1 JOHNNYS...

I have a tricky situation...i am recreating an Aging Report and have been able to show all invoices for a customer with both the invoice and payment or credit memo and have the total shown in the apply to group footer...some more background would be that the report is grouped by the apply to...

Hello all - I'm new to the forum so I'll do my best to ask the correct way. I have three columns. Column One is a date reflecting a certain files expiration date. Column Two holds a formula =DATEDIF(A1,TODAY(),"d") that I use and it gives me what I've been looking for to reflect the maturity...

I am trying to age some outstanding checks in an excel formatted 'register'. I have created columns to the right of the data entries for "1 year", "2 years", etc. representing the length of time that the check has remained outstanding. I am trying to write the formula for 2 years, 3 years ...