aging

  1. V

    Need help on Aging formula

    Hi Folks, I have 3 columns wit different dates and i want to write a formula in 4th column and my condition is to calculate the aging whichever is the latest date among the three columns. Formula needs to calculate aging from =TODAY()- Latest among the 3 columns dates.
  2. J

    Formula Help - Days since last event

    Hi - I was hoping somebody could help me out with an excel formula. I'm in operations at a landscaping company, and I'd like a better way to keep track of how many days it's been since the property was last serviced. Below is an example of the spreadsheet I have. Let's say today's hypothetical...
  3. dmxcasper2

    Aging question

    <tbody> A B C D E 1 Date Action Was Opened Commitment Date Re-Commitment Date Late to Commitment Aging 2 11/15/2018 12/10/2018 12/12/2018 3 </tbody> Problem Statement: Today's Date minus (oldest date of Column B and C, if only one date exists in either of those columns, use that...
  4. dmxcasper2

    Aging with if statement

    Problem Statement: For Row 2 I'm using =today()-A1 For Row 3 I need a a formula that perform the following logic statement under these conditions: If Column B is blank then calculate using =today()-A1 If Column B has a date then calculate Column A - Column B If Column A has a non date value...
  5. W

    Index Match is it the right tool for this job?

    I have a customer list of 14,000 rows of data and I'm trying to match the balance for those customers to an AR Aging table that only has 3,000 rows. Our customer list has many duplicate names due to having multiple billing addresses for the same customer. So to get a more refined match I have to...
  6. K

    Pivot - Help in aging report

    Dear All, I am working on aging report of vehicle stock. When some vehicles are received only today, then aging will be Zero. Formula is used is Today()-Received Date. Similarly number of days range from Zero till 300 days. When I make pivot table, i am not able find Zero number of days in the...
  7. S

    Aging Days for 2 date ranges

    I need to be able to have aging days on a report i have for cases. The Aging days need to have an If statement to have the aging days be the # between 2 date ranges summed. So a case is assigned 5/24/18. We send a request for more information on 6/20/18. Days lapse from that is 27. The...
  8. A

    Calculate No of Working days between two specific days excluding weekends

    Hi Friends, Hello Friends I need a help to achieve some formula.., When we input the date in "A1", it has to calculate No of Working days from given date till TODAY and if the No. of Working days is below 1 to 10 then it should shows "Aging 1 to 10", and if No. of Working days is between 11...
  9. K

    Stop aging when status changes

    Hi! I am seeking for a help on how to stop aging when status changes Assumption: A32 - DATE ACQUIRED G32 - AGING (# of days) I32 - STATUS (with drop down: Successfully Closed On Hold Inactive...
  10. H

    Calculating aging but ingore formulas if both dates are blank

    I am able to calculate aging in my column L based off a date entered in column K whether or not a date has been entered in column M. But what I would like is for my column L to ignore the aging formula if a beginning date has not been entered in column K. Currently excel returns a value of...
  11. S

    Extend file name

    Hi I am looking for a macro which will open all files from specified folder and rename files which is just extension to the existing file name. Example- If file name is GRIR report – It should be changed as “GRIR report as of 01312018” If file name is AR aging report – It should be...
  12. N

    Account Receivable aging and Late Payment Fees

    Hello Sirs, i have made this account receivable with aging report...i have following issues relating to formulas: 1) if the company pays during 30 days there will charge no late fees. 2) if the company pays during 60 days the amount will be deducted from previous month balance. 3) if company...
  13. R

    Remove aging list if variance is zero

    I have been put in charge of an inventory of AR items. Please see below STATUS Acct. Number MS4 Bat # Date In (Column E) AGING (Column F) Date Out Amount In Amount Out Variance Refunded 02/03/17 91+...
  14. D

    Macro Copy Main page to all worksheets

    I created a spreadsheet where I extract information from the main tab to multiple tabs based on customer number. I need to now add a header from the main sheet to all other sheets and having a hard time with a macro that will do this. I need to Copy cells A1-M5 from tab Aging and paste to all...
  15. M

    Receivables ledger to debtors aging link in same workbook.

    anyone here can make any suggestions to the following situation: i have to worksheets in a workbook one is receivables ledger and other is debtors aging now the problem here is i need a format by which i make receivables ledger entries and it records itself automatically in debtors aging and...
  16. K

    Cohort Aging Analysis using AVERAGEIF and SMALL w/ IF criteria

    Hello wise ones, I am doing some cohort analysis, and it is my first time trying functions like SMALL, LARGE, AGGREGATE, etc. This is as far as I got, and I'm stuck! I've included a Dropbox link to an Excel file with select data. In summary - (See Screenshot #1) For work, I am doing cohort...
  17. A

    Formula to calculatie aging then format cells over a specific date

    After reading through several threads on aging formulas, I wasn't able to find a way to achieve the following. I am looking for a formula that calculates the length of employment based on the anniversary date enter in another cell (D11) on the same sheet. Then a condition that changes the cell...
  18. J

    Accounts Receivable Aging in Excel

    =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...
  19. G

    Formula to calculate aging buckets?

    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...
  20. M

    Help!! Looking for an if statement

    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...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top