SOLVED

Excel cell formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1281871%22%20slang%3D%22en-US%22%3EExcel%20cell%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1281871%22%20slang%3D%22en-US%22%3E%3CP%3EA%20have%20a%20formula%20in%20a%20cell%20that%20I%20want%20to%20show%20as%20a%20date%20format%20as%20%2204%2F26%20to%2005%2F02%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20formula%20entered%20is%20%22%3DA3%26amp%3B%22%20to%20%22%26amp%3BA87%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECell%20a3%20is%20%224%2F26%2F2020%22%20%26amp%3B%20Cell%20a87%20is%20a%20formula%20%22%3DA73%2B1%22%20which%20adds%20my%20work%20week%20formatted%20in%20a%20long%20date%20format%20showing%20weekday%2C%20month%2C%20day%2C%20year.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20cell%20in%20which%20the%20formula%20is%20entered%20shows%20%2243947%20to%2043953%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20meant%20to%20show%20the%20beginning%20and%20end%20date%20of%20my%20work%20week.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20different%20date%20formulas%20to%20no%20avail.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1281871%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1281991%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20cell%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1281991%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F609525%22%20target%3D%22_blank%22%3E%40snojoe10%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20this%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DTEXT(A3%2C%22mm%2Fdd%22)%26amp%3B%22%20to%20%22%26amp%3BTEXT(A87%2C%22mm%2Fdd%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1282477%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20cell%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1282477%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAwesome!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20so%20much!%20Works%20great.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%2C%20would%20it%20be%20possible%20to%20add%20%22Hours%22%20to%20the%20end%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20again%20Riny%20for%20your%20super%20helpful%20and%20quick%20response.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1282483%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20cell%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1282483%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F609525%22%20target%3D%22_blank%22%3E%40snojoe10%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eadd%20to%20the%20formula%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%26amp%3B%20%22%20Hours%22%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1282509%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20cell%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1282509%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBingo!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20Sergei.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWorked%20perfectly!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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
Highlighted
Best Response confirmed by snojoe10 (New Contributor)
Solution

@snojoe10 

Try this:

=TEXT(A3,"mm/dd")&" to "&TEXT(A87,"mm/dd")

 

Highlighted

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

 

 

Highlighted

@snojoe10 

add to the formula

& " Hours"
Highlighted

@Sergei Baklan 

 

Bingo!

 

Thanks Sergei.

 

Worked perfectly!