Forum Discussion
Solved
Formatting
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 & ","
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
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.
