Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

How to stop count if another cell contains specific

0

Hey there, so I am working on a document for work. The formula I am currently using is

"=IF(I2="","",I2-TODAY())"

which is basically counting down the amount of remaining days to the documents due date (cell I2).  Which this works great and all, however I would like to have the count end once the Status (Cell K2) says "At Division". 

H                        I                      J                    K

Until               Due Date          Item No          Status 

23                    9/15/2016          2708          EMPLOYEE SIGNED

Is this a possible task? Thank you in advance for any help!! (first time posting)

excel
MS Office Version: 2013
posted by: lsimplicityj (rep: 2) on Tue Aug 23, 2016 at 2:24 pm
Answer
Discuss

Answers

0
Selected Answer

Try this:

=IF(K2="At Division","End",IF(I2="","",I2-TODAY()))

Replace "End" with whatever you want to appear in the cell.

posted by: don (rep: 1989) on Tue Aug 23, 2016 at 11:10 pm
Discuss

Discussion

Thank you so much, worked awesome... Really appreciate it. 
lsimplicityj (rep: 2) Aug 24, '16 at 9:51 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login