For financial modeling, adding today’s date is very useful for discounting cash flows and calculating the net present value (NPV) of an investment. The today function can also be used to create a dynamic model that calculates the number of days elapsed since a certain previous date.

Because timing can make a big difference in the value of cash flows, it’s important to be very precise about when an initial investment takes place.

Want to learn more about the TODAY function? Check out our free resource here https://bit.ly/3UnUbPn

Did you enjoy this short explainer video? Check out our full playlist of short tutorials on common topics https://bit.ly/3TWvxns

About Corporate Finance Institute
Corporate Finance Institute (CFI) is the #1 rated online provider of finance and banking training, certifications, and productivity tools. With the industry’s leading training library, we empower professionals with job-ready training and practical resources to succeed in diverse roles within finance and banking. The exceptional depth and quality of our courses stem from the extensive industry experience of our instructors, who ensure each lesson is immediately applicable. Established in 2016, CFI is the go-to resource for over 2 million individuals and thousands of organizations worldwide.

To learn more, visit our website: https://bit.ly/43U08Xq

#cfi #subtotalfunction #exceltips #excelformulas #exceltutorial