2. Then enter relevant data in the form, such as date and amount, to ensure that the date data is in the correct format, such as YY-MM-DD.
3. Then, in the cell where the futures amount needs to be calculated, use the IF function to judge whether it is expired.
4. Then, if you want to view all overdue amounts, you can use the filtering function of Excel, select table data, select the filtering option in the data menu, select the digital filtering and equal option in the filtering drop-down menu, enter "overdue" in the equal option, and then click OK.
5. Finally, calculate the total amount of all overdue items. You can use the SUMIF function.