### Step 1:

Label the watch cells : **
A1** : Customer

**B1**: rate #

**C1**: Date

**D1:**Amount Due.

Enter in the corresponding data for your customers and their orders underneath the headlines .

### Step 2:

Add extra headers for each column as :

**E1:** Days Outstanding

**F1:** not Due

**G1:** 0-30 Days

**H1:** 31-60 days

**I1:** 61-90 days

**J1:** > 90 days

#### Step 3:

adjacent, we will input a recipe for the “ Days Outstanding ” column that will let us know how many days that invoice has gone unpaid since the due date.

In cell E2, figure in the following recipe : ** =IF(TODAY()>C2,TODAY()-C2,0)**

##### Step 4:

Drag the satiate handler from cell E2 all the way to the last customer. This will populate the formula down the hale column so you do not have to enter it in over again .

##### Step 5:

now we want to give our aging report some color, so that we can easily see who is the most delinquent versus who is even in the clear. Highlight all the rows in the E column then click Conditional Formatting on the Home check and New Rule .

##### Step 6:

A branch window will open named “ New Formatting Rule ”.

Click the “ Format Style ” drop gloomy and choice 3-color scale.

Click the “ Type ” dribble down and choose Number

Under “ Values ”, enter 0 for minimum, 60 for center and 90 for maximum.

ultimately, select the colors that make the most sense for you, normally three colors that are identical far apart on the color scale.

##### Step 7:

In cell F2 we will find out who is not yet due on their invoices. The convention will check for anything in the “ Days Outstanding ” column that is adequate to zero.

In cell F2, figure in the comply formula : ** =IF(E2=0,D2,0)**

Drag the fill handler down the column to populate .

##### Step 8:

The formula for 0-30 days basically says, “ Check to see if the dispute between today ’ sulfur date and C2 ’ mho date are less than or equal to 30. If it is, input the datum from D2. If it isn ’ t, leave as 0 ”.

Enter in cell G2 the follow convention : ** =IF(C2**

Drag the fill handler down the column to populate.

##### Step 9:

The future formula will use an AND statement, which will basically say that if the difference between today ’ randomness date and that date in C2 is less than or peer to 60 days AND greater than 30 days, then input the datum from D2. Otherwise, input 0.

In cell H2, insert in the trace formula : ** =IF (AND(TODAY()-$C2<=60,TODAY()-$C2>30),$D2,0)**

Drag the meet handler down the column to populate.

Read more : How to take a screenshot on LG smartphones

##### Step 10:

Under the 61-90 days column, the formula will be alike in concept to the one input in tone 9.

In cell I2, figure in the pursue formula : **=IF(AND(TODAY()-$C2<=90,TODAY()-$C2>60),$D2,0)**

Drag the fill handler down the column to populate .

##### Step 11:

To find the unpaid invoices greater than 90 days, the recipe is quite simple. It is just stating that if the remainder between today ’ second date and the due date is greater than 90 to input the data from cellular telephone D2. Otherwise, input 0.

In cell J2, record in the pursuit convention : **=IF(TODAY()-$C2>90,D2,0)**

Drag the meet handler down the column to populate .

##### Step 12:

To sum up the value of all of the invoices in each column to know how much cash you have floating among each simply snap and puff from the first empty cell underneath the “ not Due ” column to the “ > 90 ” column. then imperativeness **ALT+=** .