Calculating Days past a suspense date

[ozzborn]

I am using Windows Vista and Excel 2007<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I am building a basic spreadsheet to track projects against given suspense’s. <o></o>
<o></o>
In cell J3 I am trying to create a formula that will report days past a given date in cell H3.<o></o>
<o></o>
Formula currently is "=Today()-H3"<o></o>
<o></o>
this reports days past the given date. However, before the suspense arrives it reports negative days as a countdown to the suspense. I want the formula to report 0 until 1 day past the suspense. <o></o>
<o></o>
I have tried incorporating;<o></o>
<o></o>
=MAX(0,J3), =IF(J3<0,0, J3) and custom formatting in the cell. Nothing has worked. <o></o>
<o></o>
What am I doing wrong? <o></o>
<o></o>
Thank you<o></o>

 

[barry houdini]

You are on the right lines......try this version in J3

=MAX(0,TODAY()-H3)

 

[VoG]

Try

=if(today()>h3,Today()-H3,0)

 

[ozzborn]

Barry thank you it worked. VoG will try yours as well.