DAYS Function:

This function calculates the number of days between two dates. The syntax is $"=$DAYS$($end$\_$date,start$\_$date$)".$

Required:

Calculate the number of days each account has been unpaid using the $=$DAYS function.

$\backslash$table$[[$Customer$,$Amount,Invoice Date,Today's Date,$\backslash$table$[[$Number of Days$],[$Unpaid$]]],[$Fitness Mania,$2,500,\frac{6}{17}\frac{?}{2022},\frac{12}{31}\frac{?}{2022},],[$Health for Life,$1,900,\frac{12}{21}\frac{?}{2022},\frac{12}{31}\frac{?}{2022},],[$Holistic Health Options,$12,750,\frac{10}{12}\frac{?}{2022},\frac{12}{31}\frac{?}{2022},],[$Image Reimaging,$7,000,\frac{12}{5}\frac{?}{2022},\frac{12}{31}\frac{?}{2022},],[$Today$\text{'}$s Gym World,$4,600,\frac{11}{29}\frac{?}{2022},\frac{12}{31}\frac{?}{2022},],[$Whole Life Fitness Center,$15,900,\frac{11}{20}\frac{?}{2022},\frac{12}{31}\frac{?}{2022},],[$Workouts Unlimited,$3,800,\frac{10}{2}\frac{?}{2022},\frac{12}{31}\frac{?}{2022},],[$Total$,48,450,,,]]$

Use the information from Requirement $1$ to complete the Aging of Accounts Receivable Schedule.

Use the $=$IF function to determine where each customer amount belongs. Do not leave any cells blank.

Use $=$ AND to check date ranges. For example, to go in Column $C_r$ a receivable must be older than $30$ days AND less than $61$ days old.

Use $=$ SUM to calculate each total. Include cells even if their amount is zero so this table can be easily updated for different receivables balances.

$\backslash$table$[[$Customer$,$Number of Days Unpaid,Total$],[0-30,31-60,61-90,$Over $90],[$Fitness Mania$],[$Health for Life$],[$Holistic Health Options$],[$Image Reimaging$],[$Today$\text{'}$s Gym World$],[$Whole Life Fitness Center$],[$Workouts Unlimited$],[$Total Accounts Receivable$],[$Estimated Uncollectible$(\%),2\%,10\%,25\%,45\%,],[$Estimated Uncollectible $($$$),,,,,]]$