skinny.

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…

Log in to save or queue this episode.

The skinny

The skinny isn't ready yet — notes appear once the transcript is processed.