Excel 2007 : Internal Date/Time conflicts

[Greenevo]

when i utilize the NOW() function on my spreadsheet with the NETWORKDAYS() function in this format NETWORKDAYS(A3, NOW()) the formula is working correctly in that it is calculating the days how i want it to except that excel's internal clock or soemthing is behind. when i do =NOW() just by itself it works correctly and has the current date/time of my computer, but with that formula the days calculated are lower then what they should be. it seems to be that way across the board, if i were to put 1 feb 12 in b1 and this formula in a1 =if(b1="", "", networkdays(b1, now())) it calculates and forms a number in this instance for today it says 36, which is about 13 short, and if i put the same formula in a2 and put 3 feb 12 in b2 the number shows up as 34 so i know it is calculating correctly its just the internal clock it goes off of for this formula is screwed up. any help would be appreciated. thank you.

[daddylonglegs]

If you use NETWORKDAYS then you are excluding weekend days so with this formula

=if(b1="", "", networkdays(b1, now()))

if B1 is 1st Feb 2012 and today is 20th March 2012 the result will be 35

Why do you expect it to be more, are you trying to count all days? If so just subtract, i.e.

=IF(B1="","",TODAY()-B1)

format result cell as general

[Greenevo]

ok that fixed that issue, thanks. but it caused another issue. i had cells formatted with a particular rule before that made it to no matter what the previous color of that cell was if it went above the value of 30 it would turn that cell red. once i put this formula in it turned all of the cells in that column red, i removed the previous rule and it didnt fix it. i am attaching my worksheet so you can see what i am talkign about. the columns i am trying to pertain this to are F and J, i want column J to show the number of days since the value i put in column F, but i want it to be blank if F is blank. also i need the cell in column J to turn red no matter what the previous color is if the value = 30 or more. hopefully this isnt yo confusing. thank you.status sheet.xlsm