custom format
If the goal is to get 3, then how about:
=RIGHT(A1,LEN(A1)-FIND(" ",A1))+RIGHT(A2,LEN(A2)-FIND(" ",A2))
Then you can enter Day 1 and Day 2, and it will calculate for you.
"JPS" wrote:
In cell A1 I'd like to enter 1 and have it displayed as "Day 1"
In cell A2 I would like to enter 2 and have it display as "Day 2"
The goal is to be able to have a formula return 3 if I sum A1:A2.
|