Another issue within the same formula

[krisryan]

I had asked a bit earlier how to get the following formula to work:

=IF(F9=" ",TODAY()-C9,F9-C9)

And that was the answer and it worked! (I was trying to use IF and AND when I didn't need it.) But now I have another issue within the same formula. F9-C9 works out perfectly (gives the amount of days between the two dates but TODAY()-C9 is giving me some crazy negative large numbers rather than the days between the two dates and I can't figure out why. As if it doesn't recognize that C9 and F9 are both dates?

Any insight? I apologize for asking two questions in the same day. I promise I am not normally so needy. :-)

[AlKey]

There is a big difference between =IF(F9=" " and =F9=""
=IF(F9=" " returns FALSE and =IF(F9="" returns TRUE
I assume you would want this

Please Login or Register  to view this content.

[JohnTopley]

If C9 is greater than TODAY() you will get a "negative" date.

[krisryan]

[QUOTE=AlKey;4741659]There is a big difference between =IF(F9=" " and =F9=""
=IF(F9=" " returns FALSE and =IF(F9="" returns TRUE
I assume you would want this

Please Login or Register  to view this content.

Thank you so much! :-)