Query Google Spreadsheets to select the minimum and maximum dates in the column.

I have a large row of data sheets with several dates per company and I have to calculate the time to get to the column level (max date – min date).

RAW DATA SOURCE:


| Data 1 | Date |

| name 1 | 1/1/2018 |

| name 1 | 1/2/2018 |

| name 2 | 1/3/2018 |

| name 2 | 1/5/2018 |

| name 2 | 1/1/2018 |

| name 2 | 1/2/2018 |

| name 2 | 1/3/2018 |

RESULT OF THE RESEARCH EXPECTED:

| Data 1 | Min Date | Max Date | Lead time

| name 1 | 1/1/2018 | 1/2/2018 | 30 days

| name 2 | 1/1/2018 | 1/3/2018 | 60 days