How To Find Out Aging In Microsoft Excel

0
251
find-aging-excel

Aging is the concept which can be used to find out the number  of days and their dues from a particular date, so in aging, we can find out the total number of days for any task and their current status either they are currently in Green, Yellow Or Red marks (according to our need and definitions)

Step By Step Process To Find Out Aging In Excel

1. Open the Microsoft excel sheet document and save it with some name i.e. Aging_Report.xls

find-aging-excel

2. Now add your columns name like student-name, student-age, task assigned date, Aging (here you can give your own sheet)

find-aging-excel

3. Now you can use this formula in your Aging column to find out the number of days starting from created date (task assigned date)

Formula: = IF(TODAY()>C5,TODAY()-C5,0)

find-aging-excel

                                       Note: C2 is the date on which we are finding out the Aging

4. Apply conditional formatting to give an identical measurement for the columns values. [i.e. Green: 0-10 Days, Yellow: 11-20 and Red: >20]

5. Choose the Aging column and then click On conditional formatting in the excel header and then click “Manage Rules”.

find-aging-excel

6. Conditional formatting popup will open, now click “New Rule”

find-aging-excel

7. Click on “Format cells that contain” link, choose the identical value to set property and then choose format link also give specific color fill format for the specific range values

find-aging-excel

8. After formatting aging column will look like below screenshot, also you will split these formatting to various columns like “>20 Days”, “>30 Days”

find-aging-excel

So that’s all for finding the aging of any data, now you are capable of finding out the aging of any data and also split in various formats reports.

Please do comment and share this article, if you are facing any technical difficulties do write us at mailtolifeguts@gmail.com

LEAVE A REPLY