Fixed Assets & Depreciation Macros

§179, bonus depreciation, MACRS, mid-quarter convention, and depreciation recapture — all automated in Excel.

• 2026-10-15 · 10 min read

  Date to Age Calculator: Turn Placed-In-Service Dates Into Years and Months Instantly

  Select a date column and an as-of date — the macro inserts a new column showing age in years and months for every date. Non-destructive, works on any date column.

• 2026-10-15 · 11 min read

  Subtotal by Category: Insert Group Totals and a Grand Total With Two Clicks

  Click the category column, click the value column, and instantly get collapsible SUBTOTAL rows at every group change plus a grand total. No typing, no formula building, no Data → Subtotal menu hunting.