Frank Ball

Software Developer

Self-taught software developer and Excel expert with on-the-job experience in VBA, SSRS/Crystal Reports report writing, SQL Server, and reporting services; 1,202 reputation with 146 answers.

https://stackoverflow.com/users/5910169/frank-ball

Software Excel Pivot Table: Elapsed Days from Bill_Date & Overdue Filter

Learn to create a pivot table in Excel calculating elapsed days (TODAY() - Bill_Date), filtering overdue bills >10 days with Bal_Amt >0, grouped by Party_Name. Beginner guide with helper columns, Excel Tables, and dynamic summaries for outstanding balances.

#data-analysis
#excel
#finance
#formulas
#pivot-table

3 answers• 1 view

03/03/2026, 04:43 PM