YouTubersLoveExcel#31: Dates, Cash Flow & Logic

4,905 views · Published 11 June 2008 · 9:27 · Indexed 15 October 2026

Channel: excelisfun · 2008 · Science & Technology

Watch on YouTube

Download Excel Files:
Start and Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/YouTubersLoveExcel31-34StartAndFinished.xls
Full Page With All File Links: http://people.highline.edu/mgirvin/excelisfun.htm

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.

More from this channel

• 3:51 YouTubersLoveExcel#19: Steady Growth Cash Flow Formula

  excelisfun

  3,557 views · 23 May 2008

• 3:44 YouTubersLoveExcel#26: Text To Column Trouble

  excelisfun

  3,595 views · 30 May 2008

• 3:30 YouTubersLoveExcel#34: Hide Columns Copy Problem

  excelisfun

  3,876 views · 11 June 2008

• 1:57 YouTubersLoveExcel#36: VLOOKUP increase based on Rating

  excelisfun

  3,053 views · 16 June 2008

• 1:39 YTLE#60: Hide Columns by Grouping

  excelisfun

  4,807 views · 18 July 2008

• 5:07 YTLE#63: Array Formula: Vendor Max Rating Min Cost

  excelisfun

  2,134 views · 23 July 2008

• 3:50 YTLE#68: 3 Ways To Use Fill Handle for Copying

  excelisfun

  2,472 views · 28 July 2008

• 8:18 YTLE#80: Conditional Format MATCH & INSUMBER functions

  excelisfun

  3,673 views · 4 August 2008