Hi,

I have a spreadsheet that I use as my expense report.

At the top it has a cell with the DATE, then many expenses in a list each with thier own date.

With the below dataset I would like to solve both of following solutions:
*Note format is (MM/DD/YY)

03/22/16
04/01/15
06/14/16
01/29/16
11/03/15
05/20/16

Soluiton 1) for the DATE cell to be equal to the last of all the dates: 06/14/16
Solution 2) for the DATE cell to be equal to: earliest date-last date (ex. 04/01/15-06/14/16)

Anyone able to help?

Thanks!