Formula to calculate days past due using IF function

[BuckNut614]

[TABLE="width: 1224"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Current Date[/TD]
[TD="align: right"]7/1/2017[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Invoice Number[/TD]
[TD]Invoice Date[/TD]
[TD]Company[/TD]
[TD]Sales Rep[/TD]
[TD]Sales Commission[/TD]
[TD]Invoice Amount[/TD]
[TD]Days Past Due[/TD]
[TD]Current[/TD]
[TD]1-30 days[/TD]
[TD] 31-60 days [/TD]
[TD]61-90 days[/TD]
[TD]Over 90 days[/TD]
[/TR]
[TR]
[TD="align: right"]10273[/TD]
[TD="align: right"]5/28/2017[/TD]
[TD]Consortium for Ocean Leadership[/TD]
[TD]Johnson[/TD]
[TD] $ 128.54[/TD]
[TD] $ 2,142.40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10282[/TD]
[TD="align: right"]6/9/2017[/TD]
[TD]MRSI Group, Inc[/TD]
[TD]Boehmer[/TD]
[TD] $ 11.66[/TD]
[TD] $ 155.40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10283[/TD]
[TD="align: right"]6/12/2017[/TD]
[TD]Natural Environment Research Co[/TD]
[TD]Lesure[/TD]
[TD] $ 56.59[/TD]
[TD] $ 1,414.80[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10321[/TD]
[TD="align: right"]5/5/2017[/TD]
[TD]Alpharma,Inc[/TD]
[TD]Lesure[/TD]
[TD] $ 5.76[/TD]
[TD] $ 144.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10323[/TD]
[TD="align: right"]5/8/2017[/TD]
[TD]Cardio Tech International Inc.[/TD]
[TD]Boehmer[/TD]
[TD] $ 12.33[/TD]
[TD] $ 164.40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10329[/TD]
[TD="align: right"]6/27/2017[/TD]
[TD]Image Acoustics, Inc.[/TD]
[TD]Lesure[/TD]
[TD] $ 192.78[/TD]
[TD] $ 4,819.40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10358[/TD]
[TD="align: right"]6/2/2017[/TD]
[TD]Ocean Dynamics Inc.[/TD]
[TD]Boehmer[/TD]
[TD] $ 33.90[/TD]
[TD] $ 452.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10370[/TD]
[TD="align: right"]5/5/2017[/TD]
[TD]Materials Sciences Corporation[/TD]
[TD]Johnson[/TD]
[TD] $ 70.44[/TD]
[TD] $ 1,174.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

In column G, enter a formula with an IF function to calculate the days past due. If the number of days since the invoice was sent (CurrentDate-Invoice Date) is greater than 30); otherwise, enter 0.
Create the following formulas to assign the value in the Invoice Amount column to one of five columns. Current, 1-30 days, 31-60 days, 61-90 days, and Over 90 days:
a.) In Current (column H), if the Days Past Due equals 0, display the invoice amount (column F); otherwise, display a blank cell.
b.) In 1-30 days (column I), if the days past due is greater than or equal to 1 and less than or equal to 30, display the invoice amount
(column F) ohterwise, display a blank cell.
c.) In 31-60 days (column I), if the number of days past due is greater than or equal to 31 and less than of equal to 60, display the
invoice amount (column F) otherwise, display a blank cell.
d.) In 61-90 days (column K), if the number of days past due is greater than or equal to 61 and less than or equal to 90, dieplay the
the invoice amount in (column F), otherwise display a blank cell.
e.) In Over 90 days (column L), if the number of days past due is greater than or equal to 91 days, display the invoice amount
(column F), otherwise display a blank cell.

 

[jtakw]

Homework?

 

[arthurbr]

Homework?

More than probably. This OP also posted homework on other forums