Forum Discussion

snojoe10's avatar
snojoe10
Copper Contributor
Apr 05, 2020
Solved

Excel cell formatting

A have a formula in a cell that I want to show as a date format as "04/26 to 05/02".   The formula entered is "=A3&" to "&A87"   Cell a3 is "4/26/2020" & Cell a87 is a formula "=A73+1" which adds...
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Apr 05, 2020

snojoe10 

Try this:

=TEXT(A3,"mm/dd")&" to "&TEXT(A87,"mm/dd")

 

snojoe10's avatar
snojoe10
Copper Contributor
Apr 05, 2020

Riny_van_Eekelen 

 

Awesome!

 

Thanks so much! Works great.

 

Now, would it be possible to add "Hours" to the end?

 

Thanks again Riny for your super helpful and quick response.

 

 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 05, 2020

    snojoe10 

    add to the formula

    & " Hours"
    • snojoe10's avatar
      snojoe10
      Copper Contributor
      Apr 05, 2020

      SergeiBaklan 

       

      Bingo!

       

      Thanks Sergei.

       

      Worked perfectly!

Resources