# aging

1. ### Gregorian Period 100-1900 and Aging

Dear All, Just like my previous inquiry i have a set of Data on the early Gregorian years starting from 100-1900. What is the best way to make the excel understand and format them under dd/mm/yyyyy and do an aging with =today() Thank you.
2. ### Hijri Date to Gregorian ( vise-versa ) below Hijri Year 100

Dear Valued Members of Mr.Excel, I hope everyone are safe with the Epidemic of Covid19. I have a huge data set I need to convert as well as sort related to very old Date Info on Hijri, Most dates are either below Hijri year 100 and around the year 100-200, I need aging to be done as well. I...
3. ### 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.
4. ### 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...
5. ### 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...
6. ### 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...
7. ### 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...
8. ### 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...
9. ### 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...
10. ### 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...
11. ### 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...
12. ### 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...
13. ### 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...
14. ### 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...
15. ### 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+...
16. ### 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...
17. ### 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...
18. ### 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...
19. ### 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...
20. ### 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...

### This Week's Hot Topics

• separating multiple Proper names (uppercase letters) from a list
I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
• 'for' Loop
Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
• Open specific pdf in folder with vba
Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
• What is wrong with this For Loop code?
I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
• Data to match
Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
• Shifting Columns
Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back