Is there a time when you ask a question, hoping for a quick answer, and then you spend the next 5 minutes listen to a long story? That’s how I feel when I only need the month, but the Excel is giving me the long date…
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!!! Best, Jason Zhang
Here is a lecture on how to use “Format as Table” and get the best of it.
How to make cells in visible, NOT just changing the color to background color.