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: https://modeloop.net/Blog/P2E8-Date-Functions-in-Excel-EOMONTH-EDATE-DATE-YEARFRAC-for-Financial-Models
📺 Watch the video lecture: https://youtu.be/WrzqeYvk7lw
🎓 Courses: Excel for Financial Modelling | AI in Project Finance Modelling
🌐 modeloop.net

ModeLoop is hosted by Samir Asadov, CFA, ranked top 3 financial modeller worldwide (FMWC), with 15 years in M&A and project finance for renewables.