Need help Updating a Formula in Excel

[jeep1993yj]

I am trying to write a formula that will show number days until due or days past due. I have been able to create that formula. =IF(G3>=TODAY(),+G3-TODAY()&" days til due",TODAY()-G3&" days past due")

The part that i need help with is to have the days total go to 0 when the word "COMPLETE" is inputted into column H.

I am not 100% sure if I should be using a different formula or not. Any help would greatly appreciated.

[Don]

Hi and welcome to the forum!

I would just add another IF statement to the outside of this formula. That may be a 'crude' fix, but it's really easy to implement and is a pretty quick fix.

=IF(H1="COMPLETE",0,Put Original Formula Here)

Change H1 to the location of the desired cell in column H and input the original formula where it says "Put Original Formula Here" and that should work.


*updated post title to be more descriptive