SOLVED

Formatting

Brass Contributor

Hi Everyone,

I have the formula below in Column B2 which works fine. It interacts with Current Date in Colum A2 and a list of Holidays in Column C2 and provide five digits value that increase by 1 daily. The format of the Formula Cell is General. I am having a hard time formatting it so that I have an equal sign in front of the value and comma (,) at the end with following two spaces [=22140,  ]. I try to achieve this format by converting the cell into Custom and placed this text in Type: “=”@”  “. It works as long the cell is not edited otherwise it gets treated as text. Thanks in advance!

=NETWORKDAYS.INTL(DATE(2022,6,23),A2,1,$C$2:$C$14) +22119 & ","Capture.PNG

2 Replies
best response confirmed by A2Z CF (Brass Contributor)
Solution

@A2Z CF 

Either set the number format to General and change the formula to

 

="="&NETWORKDAYS.INTL(DATE(2022,6,23),A2,1,$C$2:$C$14) +22119&","

 

or change the number format to the custom format   =0\,   and change the formula to

 

=NETWORKDAYS.INTL(DATE(2022,6,23),A2,1,$C$2:$C$14) +22119

Thank you so much! It works great now.
1 best response

Accepted Solutions
best response confirmed by A2Z CF (Brass Contributor)
Solution

@A2Z CF 

Either set the number format to General and change the formula to

 

="="&NETWORKDAYS.INTL(DATE(2022,6,23),A2,1,$C$2:$C$14) +22119&","

 

or change the number format to the custom format   =0\,   and change the formula to

 

=NETWORKDAYS.INTL(DATE(2022,6,23),A2,1,$C$2:$C$14) +22119

View solution in original post