Create Excel Formulas, Aged Dates and seven practical Excel formula fields.
Editor: Create Excel Formulas, Aged Dates and seven practical Excel formula fields.
Paste Excel Formulas to detail rows without first removing Excel Subtotals.
Aged and Reformatted Dates are included in EZ-Chart, EZ-Format, EZ-Pivot.

Knowledge of Excel Date Functions, Excel Text Functions and Excel Formulas is not required when creating Aged Date Fields with EZ-Format, EZ-Chart, EZ-Pivot and EZ-Stat.
Because Date Agings Categorize data and reduce the number of data points, Aged Date fields are perfect for the X-axis and Z-axis in Excel Charts and as a column field in Excel PivotTables and Excel PivotCharts
Age Dates as of Today or as of a Specific Date
Calculate To or From the specified Aging Date
From is used to Age Dates predominently before the Aging Date
As in an Accounts Receivable Aging where Invoice dates are in the past

To is used to Age Dates predominently after the Aging Date
As in an Accounts Payable Aging where Due dates should be in the future
The calculated Aging Values can be left, center or right justified
The new Field Description for the Aged Date Excel Formula field is automatic or user specified
Aged Date Fields can be created in non-subtotaled and subtotaled Excel Lists beginning in cell A1

The following applies to Elapsed Number of Days Between two Dates
Specify a cut-off maximum number of Elapsed Days to calculate and display
Elapsed Days greater than the specified cut-off go into a separate displayed overflow value
Automatically append a Default Description (Day / Days) onto the Number of Days Values
The appended Description can be user specified or suppressed

The following applies to Elapsed Number of Weeks between two Dates
Specify a cut-off maximum number of Elapsed Weeks to calculate and display
Elapsed Weeks greater than the specified cut-off go into a separate displayed overflow value
Round calculated Elapsed Weeks down, up or from the middle. you can free download EZ-Calc 5.7 now.