How to create and format Date quickly in a financial Model

Here is quick tutorial on create and format date in a financial model! The formula used here is EOMONTH. It will spit out the end of day of a given month.


If you date keeps showing a wired number series like “92487”. You need to go to format and change the cell format into date. See below:


Share it!! and Join my Email List to get more of these!!!


Jason Zhang


One comment

Leave a Reply

Your email address will not be published. Required fields are marked *