How to use the end of month excel formula to always end up with the last day of the month. Also shown is the EDATE formula
EOMONTH which is the end of month excel formula, generates the date of the last day of the required month, based on an input start date.
In this segment, you will learn how to find, activate and use these functions. However it is very important to point out, that these functions are only available when you have your Analysis Toolpack loaded.
You can visit our site to see how to load the Analysis Toolpack
In this example we have an income statement and what we’d like to do is we are going to have actual numbers dated the 15th January, and what we’d like to do is put in some forecast numbers, but we’d like this to calculate the correct dates.
We can make use of the EDATE feature, in order to activate it
And now if we want to we can
If you would like the forecast dates to make reference to the start date, but to show the date at the end of the month, you should rather make use of the EOMONTH feature. In order to activate it,
What you have now is automatically generated dates, so what you can do is
Discounting cash flows with multiple discount rates As financial models become more sophisticated users are starting to look at discounting the cash flows with multiple discount rates. However, we have noticed during our financial modelling training courses that this is … Continue reading
Advanced Excel and Financial Modeling Training in July and August 2013 Over the next 2 months we will be running a number of Excel related courses. In particular we will be covering Advanced Excel and Financial Modeling training. The dates … Continue reading
We have used Audit Excel/Miracle Solutions for all our Excel training requirements for the past 18 months, the assessment is a good tool to determine that the trainee is allocated to the correct training.– KRONES Lifecycle Service Center Africa