Latest / ModeLoop: Financial Modelling in Excel

Excel Date Functions for Financial Models: EOMONTH, EDATE, YEARFRAC (P2E8)
The four Excel date functions every financial modeller needs: DATE, EOMONTH, EDATE and YEARFRAC. Learn how Excel stores dates, how to build dynamic period headers and timelines, and how day-count conventions affect interest accruals in project finance and debt models.
In this episode:
How Excel stores dates as serial numbers
EOMONTH for month-end periods and loan schedules
EDATE for consistent project finance timelines
YEARFRAC and day-count conventions (Act/Act, Act/365, 30/360)
DATE for dynamic period headers
📖 Full blog post…
The skinny
The skinny isn't ready yet — notes appear once the transcript is processed.