stressed_out-0211

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.

small-v

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:

format

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

Best,

Jason Zhang

 

One comment

Leave a Reply

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