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
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