Concatenate 2 Dates Conditionally Using Another Cell

Hello,

I'm looking for a macro to concatentate the earliest date and the latest date in column A separated by "-", but only from the rows in which column B is the same. Additionally if the value in column B only appears once then just return the date from Column A.

Column A Column B Column C
9/16/2017 A 13 Sep - 16 Sep
9/16/2017 B 12 Sep - 16 Sep
9/15/2017 B 12 Sep - 16 Sep
9/13/2017 A 13 Sep - 16 Sep
9/13/2017 C 13 Sep
9/13/2017 B 12 Sep - 16 Sep
9/12/2017 B 12 Sep - 16 Sep

Thanks in advanced for any help or advice,

chiatbw

Leith,

Thanks so much for the reply. I apologize for the table not being a table as it seems the spaces were removed from my "columns". Perhaps I should learn how to insert tables in this forum. I haven't tried your solution yet and please correct me if I'm wrong but....

It looks like the (MIN) AND (MAX) search the entire column. I only want the min and max of dates from column A when the value in Column B is the same. So in the case above I want to return the min and max of all dates of rows/cells in column A where "specified value" is present in column B.

Blessings,

chiatbw