From the course: Excel: Financial Modeling with Dynamic Arrays

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Working with dates dynamically

Working with dates dynamically - Microsoft Excel Tutorial

From the course: Excel: Financial Modeling with Dynamic Arrays

Start my 1-month free trial Buy for my team

Working with dates dynamically

“

- [Instructor] Dates, and particularly being able to forecast dates into the future, are an important part of building a financial model. In the example that we are going to work through together, we will incorporate the EDATAE and the EOMONTH functions together with this sequence to work with our dynamic timelines. Unfortunately, there are a few functions like this that in the current version of Excel don't automatically spill, but we are going to perform a little trick to get them to spill dynamically. So here we are going to use the EDATE function to project exactly one calendar month from our start date. So we'll go in and add the EDATE, we add our start date, and then we put in our months. Ah, and you would think that it would spill across, but it does not. And so this is where we have to perform our little trick of putting in a double negative here, and that is going to force it to spill across. So if in your model you need to know the exact calendar month and date one month in…

Contents