Date formula and combining columns

Question

I have two columns of dates formulated as m/d/yyyy. (so 6/9/2025) (Sample below) I need to combine these two columns into one column formulated as JUN 9 - 13. I have tried creating a custom formula that will change each column individually to JAN 1 and JAN 5 (which works in each column), but when I try to combine the columns, the original formula appears in both the cell and in the formula above. So in the example below, using my custom formula will change the first cell to JUN 9, but if I put the curser into the cell to edit it, both the formula bar and the cell return to 6/9/2025.

My searching hasn't really let me to any solutions, and this is a task I will have to do regularly, so I'd love to have a method to follow rather than having to spend hours combining them by hand.

My version of Excel is on Microsoft 365 and is 2501. I work on a PC.

Example of the two columns:

6/9/2025	6/10/2025
6/9/2025	6/12/2025
6/9/2025	6/13/2025
6/9/2025	6/13/2025

Need these to be combined to:

JUNE 9 - 10

JUNE 9 - 12

JUNE 9 - 13

JUNE 9 - 13

Thank you for any help!

Answer 1

Hi,

In cell A8, enter this formula

=TEXT(A2:A5,"mmmm")&" "&TEXT(A2:A5,"d")&" - "&TEXT(B2:B5,"d")

Hope this helps.

Answer 2

Let's say the dates are in columns C and D, starting in row 2.

In another cell in row 2:

=UPPER(TEXT(D2, "mmmm d")&" - "&TEXT(E2, IF(MONTH(D2)=MONTH(E2), "d", "mmmm d")))

This can be filled down, or you can use

=UPPER(TEXT(D2:D100, "mmmm d")&" - "&TEXT(E2:E100, IF(MONTH(D2:D100)=MONTH(E2:E100), "d", "mmmm d")))

Adjust the ranges to match your setup.