snojoe10Copper ContributorApr 05, 2020SolvedExcel 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...Show MoreRiny_van_EekelenApr 05, 2020snojoe10 Try this:=TEXT(A3,"mm/dd")&" to "&TEXT(A87,"mm/dd")
snojoe10Copper Contributor to SergeiBaklanApr 05, 2020SergeiBaklan Bingo! Thanks Sergei. Worked perfectly!
