Stop counting dates when date complete cell is filled?

[Finlaysm]

Hi all,

I’m new to excel so bear with!

I currently have a sheet for date countdowns, which currently consists of 4 columns:

1-start date
2-due date =IF(F2=””,””,F2+60)
3-remaining days =IF(F2=””,””,G2+TODAY())
4-date complete

So far, when I input the start date in the F column, it auto populates my due date (60 days time) in the G column and then calculates how many days remaining in the H column. How do change the H column so that when I put in the completed date (which will be in the I column), it removes the remaining days and changes it to say “completed”?

Thanks! :D

 

[Jeffrey Mahoney]

=IF(I2<>"","Completed",G2-Today())

 

[Finlaysm]

=IF(I2<>"","Completed",G2-Today())

Thank you!! Is there a way you can keep the cell blank, until the start date cell is filled? I copied the formula to cells below and it shows #VALUE!

 

[Jeffrey Mahoney]

=IF(I2<>"","Completed",if(F2<>"",G2-Today(),""))

 

[Jeffrey Mahoney]

You put that formula in Cell H2 and copied down? and got a #VALUE?. Post a portion of your table using XL2BB

 

[Finlaysm]

=IF(I2<>"","Completed",if(F2<>"",G2-Today(),""))

Amazing! Thank you, I’ve copied this and this is exactly what I was looking for!

Going to try and understand how it works now lol, thank you again!

 

[Jeffrey Mahoney]

Nested IF statements are just the beginning. If you are ready to start your journey down the Excel rabbit hole, stick around.

 

[Finlaysm]

Nested IF statements are just the beginning. If you are ready to start your journey down the Excel rabbit hole, stick around.

Believe me I am truly at the beginning but ready to learn, I’m sure you’ll hear from me again soon!