Apr 04 2020 06:25 PM
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.
Apr 04 2020 10:10 PM
SolutionApr 05 2020 07:28 AM
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.
Apr 05 2020 07:46 AM
Apr 04 2020 10:10 PM
Solution