Excel Forum



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.