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 my work week formatted in a long date format showing weekday, month, day, year.

 

The cell in which the formula is entered shows "43947 to 43953"

 

It is meant to show the beginning and end date of my work week.

 

I've tried different date formulas to no avail.

 

 

4 Replies

Resources