Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



YouTubersLoveExcel#31: Dates, Cash Flow & Logic


See how to use Date Math, EOMONTH, IF & AND functions to assign contractual cash flows to the correct period.

See a formula that will calculate the last day of the Contract.
See a formula that will assign the correct contractual cash flow to the correct period.

Learn about the importance of Date Math in formulas.
See and AND function that uses three logical tests.





Got a Question? Ask it Here in the Forum.