Cells C8:C71 contain the dates the assignments are due
Cells D8:D71 contain the dates the assignments were sent in
Cells A8:A71 contain the title of the assignment
I want it to tell me what assignment is due next in cell E6, and another to tell me what assignment was last sent in and place this in cell L6- that's it.
Example: Excel Project 1 (assignment) $A$8 August 11, 2008 $C$8 (date due) August 10, 2008 $D$8 (Date Sent) so in E6 would return Excel Project 2 (A9) and L6 would return Excel Project 1
Microsoft Office