Add DATEDIF or Completed

[Klarkin]

Hope someone can help. I've managed to get myself lost adding a number of days or COMPLETED formula. Essentially, I need to count the number of days since a task was completed so in J2 I've added =DATEDIF(I2,TODAY(),"d"). When the task is complete I need to add another date into K2 and for this to alter the record in J2 to the text COMPLETED. I've used Excel for years but am only now trying to write formula myself. Many thanks

 

[arthurbr]

Perhaps =IF(K2<>"","COMPLETED",DATEDIF(I2,TODAY(),"d"))

 

[Klarkin]

Perhaps =IF(K2<>"","COMPLETED",DATEDIF(I2,TODAY(),"d"))

Thank you, much appreciated

 

[Peter_SSs]

Welcome to the MrExcel board!

Since dates in Excel are represented by integers, when dealing with days, you can simply add or subtract the dates rather than resorting to DATEDIF.

=IF(K2<>"","COMPLETED",TODAY()-I2)

 

[Klarkin]

Thanks very much. I'm learning fast, wish I'd taken it seriously years ago!

 

[Peter_SSs]

Thanks very much. I'm learning fast, wish I'd taken it seriously years ago!

You're welcome