leaving the cell blank

finchy11

New Member
Joined
Jul 18, 2014
Messages
1
[TABLE="width: 266"]
<COLGROUP><COL style="WIDTH: 76pt; mso-width-source: userset; mso-width-alt: 3232" width=101><COL style="WIDTH: 93pt; mso-width-source: userset; mso-width-alt: 3968" width=124><COL style="WIDTH: 97pt; mso-width-source: userset; mso-width-alt: 4128" width=129><TBODY>[TR]
[TD="class: xl63, width: 101, bgcolor: transparent"][TABLE="width: 248"]
<COLGROUP><COL style="WIDTH: 88pt; mso-width-source: userset; mso-width-alt: 4278" width=117><COL style="WIDTH: 98pt; mso-width-source: userset; mso-width-alt: 4790" width=131><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2998" width=82><TBODY>[TR]
[TD="class: xl74, width: 117, bgcolor: transparent"][/TD]
[TD="class: xl67, width: 131, bgcolor: transparent"][/TD]
[TD="class: xl67, width: 82, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl91, width: 117, bgcolor: #99ccff"]Date Raised[/TD]
[TD="width: 131, bgcolor: transparent"]<v:shapetype id=_x0000_t75 stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o:preferrelative="t" o:spt="75" coordsize="21600,21600"><v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><v:path o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"></v:path><o:lock aspectratio="t" v:ext="edit"></o:lock></v:shapetype><v:shape style="Z-INDEX: 4; POSITION: absolute; MARGIN-TOP: 9.75pt; WIDTH: 0px; HEIGHT: 32.25pt; MARGIN-LEFT: 0px" id=_x0000_s140289 filled="t" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="window [65]" type="#_x0000_t75"><v:imagedata o:title="" src="file:///C:\Users\FG0005~1\AppData\Local\Temp\msohtmlclip1\01\clip_image001.emz"></v:imagedata><x:ClientData ObjectType="Pict"><x:SizeWithCells></x:SizeWithCells><x:CF>Pict</x:CF> </x:ClientData></v:shape><v:shape style="Z-INDEX: 5; POSITION: absolute; MARGIN-TOP: 3pt; WIDTH: 0px; HEIGHT: 48pt; MARGIN-LEFT: 0px" id=_x0000_s140290 filled="t" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="window [65]" type="#_x0000_t75"><v:imagedata o:title="" src="file:///C:\Users\FG0005~1\AppData\Local\Temp\msohtmlclip1\01\clip_image002.emz"></v:imagedata><x:ClientData ObjectType="Pict"><x:SizeWithCells></x:SizeWithCells><x:CF>Pict</x:CF> </x:ClientData></v:shape><v:shape style="Z-INDEX: 6; POSITION: absolute; MARGIN-TOP: 3pt; WIDTH: 0px; HEIGHT: 48pt; MARGIN-LEFT: 0px" id=_x0000_s140291 filled="t" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="window [65]" type="#_x0000_t75"><v:imagedata o:title="" src="file:///C:\Users\FG0005~1\AppData\Local\Temp\msohtmlclip1\01\clip_image003.emz"></v:imagedata><x:ClientData ObjectType="Pict"><x:SizeWithCells></x:SizeWithCells><x:CF>Pict</x:CF> </x:ClientData></v:shape><v:shape style="Z-INDEX: 7; POSITION: absolute; MARGIN-TOP: 3.75pt; WIDTH: 0px; HEIGHT: 47.25pt; MARGIN-LEFT: 0px" id=_x0000_s140292 filled="t" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="window [65]" type="#_x0000_t75"><v:imagedata o:title="" src="file:///C:\Users\FG0005~1\AppData\Local\Temp\msohtmlclip1\01\clip_image004.emz"></v:imagedata><x:ClientData ObjectType="Pict"><x:SizeWithCells></x:SizeWithCells><x:CF>Pict</x:CF> </x:ClientData></v:shape><v:shape style="Z-INDEX: 8; POSITION: absolute; MARGIN-TOP: 5.25pt; WIDTH: 0px; HEIGHT: 45.75pt; MARGIN-LEFT: 0px" id=_x0000_s140293 filled="t" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="window [65]" type="#_x0000_t75"><v:imagedata o:title="" src="file:///C:\Users\FG0005~1\AppData\Local\Temp\msohtmlclip1\01\clip_image005.emz"></v:imagedata><x:ClientData ObjectType="Pict"><x:SizeWithCells></x:SizeWithCells><x:CF>Pict</x:CF> </x:ClientData></v:shape><v:shape style="Z-INDEX: 9; POSITION: absolute; MARGIN-TOP: 5.25pt; WIDTH: 0.75pt; HEIGHT: 45.75pt; MARGIN-LEFT: 0px" id=_x0000_s140294 filled="t" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="window [65]" type="#_x0000_t75"><v:imagedata o:title="" src="file:///C:\Users\FG0005~1\AppData\Local\Temp\msohtmlclip1\01\clip_image006.emz"></v:imagedata><x:ClientData ObjectType="Pict"><x:SizeWithCells></x:SizeWithCells><x:CF>Pict</x:CF> </x:ClientData></v:shape><v:shape style="Z-INDEX: 10; POSITION: absolute; MARGIN-TOP: 9.75pt; WIDTH: 0px; HEIGHT: 32.25pt; MARGIN-LEFT: 0px" id=_x0000_s140295 filled="t" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="window [65]" type="#_x0000_t75"><v:imagedata o:title="" src="file:///C:\Users\FG0005~1\AppData\Local\Temp\msohtmlclip1\01\clip_image001.emz"></v:imagedata><x:ClientData ObjectType="Pict"><x:SizeWithCells></x:SizeWithCells><x:CF>Pict</x:CF> </x:ClientData></v:shape><v:shape style="Z-INDEX: 11; POSITION: absolute; MARGIN-TOP: 12.75pt; WIDTH: 0px; HEIGHT: 27pt; MARGIN-LEFT: 0px" id=_x0000_s140296 filled="t" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="window [65]" type="#_x0000_t75"><v:imagedata o:title="" src="file:///C:\Users\FG0005~1\AppData\Local\Temp\msohtmlclip1\01\clip_image007.emz"></v:imagedata><x:ClientData ObjectType="Pict"><x:SizeWithCells></x:SizeWithCells><x:CF>Pict</x:CF> </x:ClientData></v:shape><v:shape style="Z-INDEX: 12; POSITION: absolute; MARGIN-TOP: 6.75pt; WIDTH: 0px; HEIGHT: 41.25pt; MARGIN-LEFT: 0px" id=_x0000_s140297 filled="t" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="window [65]" type="#_x0000_t75"><v:imagedata o:title="" src="file:///C:\Users\FG0005~1\AppData\Local\Temp\msohtmlclip1\01\clip_image001.emz"></v:imagedata><x:ClientData ObjectType="Pict"><x:SizeWithCells></x:SizeWithCells><x:CF>Pict</x:CF> </x:ClientData></v:shape><v:shape style="Z-INDEX: 13; POSITION: absolute; MARGIN-TOP: 5.25pt; WIDTH: 0px; HEIGHT: 43.5pt; MARGIN-LEFT: 0px" id=_x0000_s140298 filled="t" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="window [65]" type="#_x0000_t75"><v:imagedata o:title="" src="file:///C:\Users\FG0005~1\AppData\Local\Temp\msohtmlclip1\01\clip_image001.emz"></v:imagedata><x:ClientData ObjectType="Pict"><x:SizeWithCells></x:SizeWithCells><x:CF>Pict</x:CF> </x:ClientData></v:shape>

<TBODY>
[TD="class: xl89, width: 131, bgcolor: #99ccff"] Closed - Actual [/TD]

</TBODY>
[/TD]
[TD="class: xl89, width: 82, bgcolor: #99ccff"]<v:shape style="Z-INDEX: 3; POSITION: absolute; MARGIN-TOP: 0px; WIDTH: 0px; HEIGHT: 0px; VISIBILITY: visible; MARGIN-LEFT: 36.75pt; mso-wrap-style: square; v-text-anchor: top" id=Freeform_x0020_9316 stroked="f" path="m225,l193,,153,8,108,33,66,70,39,97,21,135,4,174,,224r,38l5,292r11,29l27,344r19,22l66,386r33,22l118,421r25,12l168,440r27,5l222,446r23,l262,445r22,-9l300,430r22,-9l342,413r15,-9l376,399r15,-11l404,381r15,-13l439,358r22,-4l478,353r17,1l508,358r15,6l535,368r12,10l563,388r15,13l590,416r10,17l610,456r12,32l600,480r-22,-7l553,470r-15,-2l525,470r-22,5l488,485r-15,18l453,528r-14,25l431,600r5,37l451,667r19,28l486,709r22,8l532,720r31,l593,714r34,-12l650,682r16,-30l676,627r,-9l686,622r35,88l908,710r-1,-6l902,687,868,618,820,515,773,418,748,366,721,338,687,307,644,286r-32,-5l568,277r-40,9l490,304r-39,32l421,356r-30,12l356,374r-37,7l304,381r-34,l237,368,208,348,183,331,166,307,155,282,145,261r-5,-27l138,197r5,-28l155,144r11,-25l183,103,198,87r9,-5l203,110r-3,30l212,172r10,20l240,209r20,15l285,227r22,l339,222r27,-13l381,187r15,-23l403,147r,-30l397,92,387,68,366,45,336,25,307,11,282,6,245,,225,xe" coordsize="908,720" o:insetmode="auto" fillcolor="blue" o:gfxdata="UEsDBBQABgAIAAAAIQC75UiUBQEAAB4CAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSRvU7DMBSF
dyTewfKKEqcMCKEmHfgZgaE8wMW+SSwc27JvS/v23KTJgkoXFsu+P+c7Ol5vDoMTe0zZBl/LVVlJ
gV4HY31Xy4/tS3EvRSbwBlzwWMsjZrlprq/W22PELHjb51r2RPFBqax7HCCXIaLnThvSAMTP1KkI
+gs6VLdVdad08ISeCho1ZLN+whZ2jsTzgcsnJwldluLxNDiyagkxOquB2Knae/OLUsyEkjenmdzb
mG/YhlRnCWPnb8C898bRJGtQvEOiVxjYhtLOxs8AySiT4JuDystlVV4WPeM6tK3VaILeDZxIOSsu
ti/jidNGNZ3/J08yC1dNv9v8AAAA//8DAFBLAwQUAAYACAAAACEArTA/8cEAAAAyAQAACwAAAF9y
ZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj39ubi6AgeJtl2G9m6vYx
jeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLBBhaZ4ljBkFLYSMl6oAm5
8IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZTVuvrxO59CNCmoj3vCwj
MfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAAACEAAwv3mIAJAABoNAAA
HwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWykWk2P2zYQvRfofxB0LNBY1LcWcXJo
m1zSJkC3P0CxtetFbdmQFe/m3/cNRXk1qjgetLlIa70Zct6jKPIxb9+/HPbBpenOT8d2HZo3URg0
7ea4fWof1+Ff9x9+LsPg3Nfttt4f22Ydfm/O4ft3P/7wtr577OrT7mkTIEN7vqvX4a7vT3er1Xmz
aw71+c3x1LR49nDsDnWPP7vH1barn5H5sF/FUZSvDvVTG757TfVr3dfBt+7pP6TaHzd/N9tf6vZS
n5Fyv7mb/uL6uN/8/8z1XXv52J3+PH3pqOebPy5fuuBpuw7BXFsfQFG4cg8cDH+uZlGPrwleHroD
4Y8PD8HLOsyjtEyKLAy+r8M0LvM4G9I1L32wwXO0ssGjyDWy+yyHbXa/LQSiO0OzuJl05XyijrSX
f9eWjrV96JqGBA2qxOTXQseA8+kTZDgPBYOZ4Xdb/CsEdH19/v24BVP1t/5o9Z+RUBR5XCpJuNYC
Lb6d+4/N0dJZXz6deyvE4xZ3VNjj1gl0DxIfDnuM2J9WQRQ8B1VUDrW8QgyD7IIidpS/QmIGWcyS
MMhiFlB7qy8YDRPIYpacQRb7UjDIYha865OGFrNUDLKYxWjoVfBrFAQbBcNGQbFRcIwBf5Meo2DZ
KGg2Cp4xIm/2J1bwHCt4jhU8xwqeMZ1N+7w4fmIFz7GC51jBc6zgOVHwnCh4ThQ8JwqeEwXPiYLn
RMFzouA5UfCcKHhOFTynCp5TBc+pgudUwXOq4DlV8JwqeE4VPKcKnjMFz5mC50zBc6bgOVPwnCl4
zhQ8ZwqeMwXPmYLnXMFzruA5V/CcK3jOFTznCp5zBc+5gudcwXOu4LlQ8FwoeC4UPBcKngsFz7S4
nSy1Fr+DhYLnQsFzoeC5UPBcKnguFTyXCp5LBc+lgudSwXPJec4j/AvyLMP30W0gxn1DydmWkJxz
CcmZF5AV519CchUkJNdCQnJFJCTXRUJydSSkWqNKrVGl1qhSa2QitUgmUqtkIrVMJlLrZCK1UCZS
K2UitVQmUmtlsEOfTpjCUDGRXq3ZVlXKavRqzTauYla9WrNtrJhVr9ZsUytm1as12+KKWfVqzTa8
UtbZvleE6t+t2S5YzKp/t2Z7YjGr/t2a7ZDFrPp3a7ZfXrSIzGzDvLi4MWzHDAPOY8OxTTNMuOCa
jbzL0dqrd6Pbt3lpnd2Hu6AmF/seH3jy/07HMzms5P7BQb039HVHEuDo6QReMDiGB8ETL7xkcOhO
cGvbLmavGByCErzwZcdHf9p3KEXwygs3DE7zG+ExeXmKrWIe4KqFr+YLSHiAqxcGmi8g5QGuYjhl
voCMB7iaYYn5Ari+NE1Q0ZgDfAEzhV3ReL19AVxjcrpsC/6iucpkadkAb9G0cJgKTeaVjfBWTeuH
aQS9dRSBF8tTBS0jWMQ4tL1102qCRbjCYS952+Byk8lkeyVUzvUmO8lGCJVzwck4ogiYQ95eccXJ
IrIRQuVccjKDbIRQOdecbB8b4a8cr+eUXTJ4bIS/crzI0wiycigCdo2vcixGWISrHMaMN4JrTvaM
bcNfOZYmrA1XOcwWbxtcc7JcbBtC5VxzMlcoAgaKtw2uOdkoNkKonGtOhomNECrnmpM1YiP8lWN2
mnJFJoiN8FeOeWwaQXYHRcDS8FUOR59FuMphXngjuOZkYdg2/JVjDmRtuMphSHjb4JqTLWHbECrn
mpMBQREwGbxtcM3JarARQuVcczIVbASrfPiQu4VF12z6YI9+GFoN9XRDc29nb7BL+GpvYuojFh11
T2uT8TZ4Xod02hjs1iEdKdLvh+OluT9aRE8LlJgWhOiDPXBEy6/P9+0UZypsHia48el4PdlshixY
oOwJJ7KNT8erQ1GfgML5w0Dt+Hi8DjA3vjEEJRSZ/ciFnbiEoiU6UOb6LRmbGq9Dk4MeBiNSSjaM
jBiDUoHCTCChBvZjrIwkFG2ciLDrKmPs9ngduk/LcILh+yFlcx+LBARLMMd/ghWtBCO/Ao2mw7G2
X3TaphHuRg2GTksId2N0GDeZpfggS90z1UBxitMTCRfTySS1C3ZEHJ3CaHDuE3CzXTcJpIMD6OUv
IbPH8iLXm4x13OA5ccuS9Lr6HsfSeB3GVEKnGNQuDByJl4QcZOASjAcRVw2vYlLKkwS1Z/NdJ+Cx
X+PVvbJ0ek3tYjxI7aZuokjw+RdxdEpC+bAUEXHuk5JcFzdjv8ar658bf7fyZeOkeKN/GfkCtl65
fxmdyip4yeg0kHCoR6o3o1Mfwt3QLXO8pNgxiPnIYUa+dPivPd5xDy9hwN2YD3K3/UxxMie1m4/v
x406ru1iISDlQ73/AAAA//+MV8uS2kAM/BWKH1hLmoeHWrhsQi455JAfcIBaqHVsCns3yd9HMyNv
HgcJLoyLRppuaVrj9erXdu0irR92jw/dph++jrvHP9/XefVzu/aeBNfoOGorLrQ6Dv198Zolr1fj
uVbytgaOeWa+nuNqfJ3w9ajzcJRqPMar8QgKLjS6fo5CxVHU43mJFwxcbGq8ZOjS1ryxSWpe31Sd
I+h5PWHJG1Hn60Oth4lLggOn7i9grHkb1HFedGkNXJB6eAMXBcf5tT4ICw70vgpSj4B63oi1DyLo
Oqf3ulm4RT9d58T65nMUWp1vyz5QcAbflvuknEvQ+zTK+XVGvOhqXuL6afVY9CP2LQ2Xeeb9UaPz
Dc4VHHL91HhQ9cMWVJwX/TDqebNP5f1ZeV2qOlOj19eJvxD7kcbDSf+R13GUap+SMRdynKJz1PdH
UH2XDP0yzxLPwKH4pBUP2ZdLPIMHynkj7kNNP2irrxHPBxUnPmT1H/g6V9HwNXCCC0ZeV/sFSa8H
yNyHpPcpuMoXgj5nFh7A5+keXYD7QcWJzmDMfUj1HBm2hmwDuQ0MlVFuL2C4M/KtIIcDVltjgeIa
EPWpgDw1Srxk4JbqGlMfg3QB6tVAvn3lvGhMwdzFd+HkdpX5aLpkly/xDB75dBddjPJSqvEg6Hzd
Ul+nd/07zrg1EZ+evD+jbCTDyPCgRRU+6qp4cuXkG7kKk5qBbhjZeDIFfRyg2I/R7vKS8D/q0I/T
qe712s3n8tqSF5+nuawPr9P86TR+z68x09hfjvtL35eH2/O3p/62euv67brhz34vnP+B9cPqBxfB
c/r8r2HM/+d83eY2vg7HsjqfuuNHWc/dpa/r8v5U9jBdv9xkwV/9YdOPh5fT8akb3rqp/PB8667n
y+FDN3d/P+9+AwAA//8DAFBLAwQUAAYACAAAACEAi2YtaLwGAADpGwAAGgAAAGNsaXBib2FyZC90
aGVtZS90aGVtZTEueG1s7FlPbxw1FL8j8R2subfZ/81G3VTZzW4Lbdoo2Rb16J3xzrjxjEe2N+ne
UHtEQkIUxAWJGwcEVGolLuXTBIqgSP0KPNszs+PsLElKBAKaQ3bmzc/v+f31s3312sOYoUMiJOVJ
z6tfrnmIJD4PaBL2vLvj0aV1D0mFkwAznpCeNyfSu7b57jtX8YbPaDrhWATjiMQEAaNEbuCeFymV
bqytSR/IWF7mKUng25SLGCt4FeFaIPARCIjZWqNW66zFmCbeJnBUmtGQwb9ESU3wmdjXbAhKcAzS
70yn1CcGGxzUNULO5YAJdIhZzwOeAT8ak4fKQwxLBR96Xs38eWubV9fwRjaIqRVjS+NG5i8blw0I
DhpGpggnhdD6qNW9sl3wNwCmlnHD4XAwrBf8DAD7Pmhq51Lm2Rqt1/s5zxLIPi7zHtTatZaLL/Fv
Ls252+/3291sLpapAdnH1hJ+vdZpbTUcvAFZfHsJ3+pvDQYdB29AFt9Zwo+udDstF29AEaPJwRJa
O3Q0yrgXkClnNyrh6wBfr2XwBQqioYguLWLKE7Uq1mL8gIsRADSQYUUTpOYpmWIfYnKA44mgWAvA
GwSXvliSL5dIWhaSvqCp6nnvpzjxSpDXL759/eIZev3i6fGj58ePfjh+/Pj40feWlzPwBk7C8sBX
X3/y+5cfot+effXqyWfVeFnG//zdRz/9+Gk1EDJooeHLz5/+8vzpyy8+/vWbJxXwLYEnZfiYxkSi
2+QI7fEYdDOGcWdOJuJ8I8YRps4IHAHvCtZDFTnA23PMqnB94hrvnoDiUQW8PnvgzHU/EjNFKyTf
jGIHuMM563NRaYCbWlbJwuNZElYLF7Mybg/jwyrZA5w4rh3OUqiaeVA6th9ExJnmLsOJwiFJiEL6
Gz8gpEK7+5Q6dt2hvuCSTxW6T1Ef00qTjOnECaTFoBs0Br/Mq3QGVzu22bmH+pxVab1NDl0kJARm
FZMfE+aY8TqeKRxXsRzjmJUNfgurqGqS+3Phl3FDqcDTIWEcDQMiZdWYOwL0LTn9JoZ6Ven2HTaP
XaRQ9KCK5y3MeRm5zQ8GEY7TKuw+TaIy9j15ACGK0S5XVfAd7maIfgc/4GSlu+9R4rj79EJwl4bO
lBYBor/MhPYlFGqn/sY0+bNizChUYxsDb4txz9uCpakqJW6cKMGrcP/CwruNZ8kugVhfXnje1t23
ddf7z9fdVbl81mq7KLBQe3XzYPti0yXHK5vkKWVsX80ZuSVNnyxhsQhGQNTjzGaQFJumNILHrLg7
uFBgMwYJrj6gKtqPcAo9dt3TTEKZsQ4lSrmEvZ0hV/LWeOjTld0ZtvWewdYDidUODyy5qcn51qBg
Y5ac0Ow/c0FNzeCswppXMqag9psIq+tJnVla3UzNlDpHWqEy+HBZNSAW1oQuBEHvAlbuwHZci4a9
CWYk0Ha3C3DuFuOFi3SRjHBAMh9pvZd9VDdOymPFHAZA7FT4SO/zTrFaSVpXs/0L0s7ipLK41gpx
uff+ipfyCF54SeftiXRkSTk5WYKOel633Wh7yMdpz5vCthYe4xS8LnXjh1kIB0K+EjbsT01mk+UL
b3ZzxdwkqMNJhbX7ksJOHUiFVNtYRjY0zKcsBFiiJdn5N9pg1otSwEb6G8yiuQ7B8I/NAuzoupZM
p8RXZWeXKNp29jUrpXymiNiPgiM0YTOxh8H9OlRBn4BKOJ0wFUG/wFGatrb55BbnLOnKB1gGZ+mY
pRHOyq1O0TyTLdzkcTEH81aaHuhWOXej3PlVMSl/QaqUw/h/popeT+C4oBloD/hwLisw0vna87hQ
EYcqlEbUHwloHEztgGiB41j4DEEFh8jmV5BD/WtzzvIwaQ27PrVHQyQorEcqEoTsQlky0XcKs3q2
dlmWLGNkIqo0XZnaaU/IIWFjXQM7em33UAShbqpJVgYM7mT8ue9ZBk1C3eSU882pIcXaa3Pg7+58
bDKDUm4dNg1Nbv9iihWrqh1vhudrb1kR/WHRZrXyrABhpaWgm6X9G07hnEutrVhLGjfa+eTAi8sa
A7FoiFI49EH6H6x/VPjMXjjoBXXM96C2Irhr0MwgbCCqL9nGA+kCaYkTaJws0QaTZmVNm7VO2mr5
Yn3BnW4h94Sx9czO4u9zGrtozlxxTi5epLEzCzu2trSVpgbPnkxRIE3zjYxxTNXF0w5O0SSs9zy4
/AFHP4QnuD7ygNbQtIamwRPcCUGzZC9yel72kFPgu6UUmGZOaeaYVk5p5ZR2ToHmLLsyySkdqFT6
lgNu2fSPh/ILDejgsguQvKg6t3ObfwAAAP//AwBQSwMEFAAGAAgAAAAhAJxmRkG7AAAAJAEAACoA
AABjbGlwYm9hcmQvZHJhd2luZ3MvX3JlbHMvZHJhd2luZzEueG1sLnJlbHOEj80KwjAQhO+C7xD2
btJ6EJEmvYjQq9QHCMk2LTY/JFHs2xvoRUHwsjCz7DezTfuyM3liTJN3HGpaAUGnvJ6c4XDrL7sj
kJSl03L2DjksmKAV201zxVnmcpTGKSRSKC5xGHMOJ8aSGtHKRH1AVzaDj1bmIqNhQaq7NMj2VXVg
8ZMB4otJOs0hdroG0i+hJP9n+2GYFJ69elh0+UcEy6UXFqCMBjMHSldnnTUtXYGJhn39Jt4AAAD/
/wMAUEsBAi0AFAAGAAgAAAAhALvlSJQFAQAAHgIAABMAAAAAAAAAAAAAAAAAAAAAAFtDb250ZW50
X1R5cGVzXS54bWxQSwECLQAUAAYACAAAACEArTA/8cEAAAAyAQAACwAAAAAAAAAAAAAAAAA2AQAA
X3JlbHMvLnJlbHNQSwECLQAUAAYACAAAACEAAwv3mIAJAABoNAAAHwAAAAAAAAAAAAAAAAAgAgAA
Y2xpcGJvYXJkL2RyYXdpbmdzL2RyYXdpbmcxLnhtbFBLAQItABQABgAIAAAAIQCLZi1ovAYAAOkb
AAAaAAAAAAAAAAAAAAAAAN0LAABjbGlwYm9hcmQvdGhlbWUvdGhlbWUxLnhtbFBLAQItABQABgAI
AAAAIQCcZkZBuwAAACQBAAAqAAAAAAAAAAAAAAAAANESAABjbGlwYm9hcmQvZHJhd2luZ3MvX3Jl
bHMvZHJhd2luZzEueG1sLnJlbHNQSwUGAAAAAAUABQBnAQAA1BMAAAAA
" o:spid="_x0000_s140303"><v:path o:connecttype="custom" textboxrect="0,0,908,720" o:connectangles="0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0" o:connectlocs="0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0;0,0" arrowok="t"></v:path></v:shape>Days open[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD="class: xl87, bgcolor: transparent"]01-Jan-14[/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl88, width: 82, bgcolor: transparent"]144[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD="class: xl63, width: 124, bgcolor: transparent"][/TD]
[TD="class: xl63, width: 129, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]
=IF(T4=0,NETWORKDAYS(TODAY(),F4),NETWORKDAYS(F4,T4))

I am using this formula it works fine but if i have no date in the date raised it gives me a large figure and i want this to show blank any idea's
[/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[TD="class: xl63, bgcolor: transparent"][/TD]
[/TR]
</TBODY>[/TABLE]
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Code:
=IF("CellAddressofDateRaisedCellHere"="","",IF(T4=0,NETWORKDAYS(TODAY(),F4),NETWORKDAYS(F4,T4)))
 
Upvote 0
I don't know what T4 and F4 are. But you just need to add in another IF statement.

Code:
If("Date Raised Cell Code" = "", "", [Here goes the rest of your code]
 
Upvote 0

Forum statistics

Threads
1,223,214
Messages
6,170,771
Members
452,353
Latest member
strainu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top