CODEWITHSUNDEEP
excel
John
John

Reputation: 1015

Creating an Excel formula that takes the date range from a column

I have a table that contains Date column with dates that look like this:

Ex:

enter image description here

In the example above the Excel formula should look at the range and show the following output: 

1/23/18 - 1/25/18

How can this be done?

Upvotes: 0

Views: 45

Answers (1)

cybernetic.nomad
cybernetic.nomad

Reputation: 6368

If those are actual dates (and not strings that look like dates), then they are numbers and you can extract the minimum and maximum values in the range, the format them:

=CONCATENATE(TEXT(MIN(A1:A10),"DD/MM/YYYY")," - ",TEXT(MAX(A1:A10),"DD/MM/YYYY"))

(in the above, I assumed the dates were in A1:A10)

Upvotes: 1

Related Questions