count if with two variables

[Alaskan_grunt]

Ok looking for guidance on this formula.

Cell O7 is the date the case was closed but Cell P7 is the date the case was pulled aka I didnt close it since it was pulled from me and no longer an active case.

My question is what tweek needs to be made to the below mentioned formula to show the result of Closed vs Pulled.

I'd like to have the cell show a result of the days open if no data is in cell O7 or P7 but if there is a date in O7 have it show CLOSED and if there is a date in P7 have it show INACTIVE.

What would be the best formula?

Currently this is the formula being used.

Please Login or Register  to view this content.

Original Post can be found here

[protonLeah]

You need to post a workbook. Your original thread has data in A1, E2:H2. Then you posted a formula referencing cells B1, I3, O3 & P3.
Now, the current post has data in H7, O7, P7 and X3. Very confusing.

[avk]

You have attach sample file, its more helpful for both.
When you are going with two dates, close date always grater than other date.
As per my assuming try

Please Login or Register  to view this content.

[Alaskan_grunt]

Ok please see attached sample file.

Row 5 is the row that should be showing a case status of inactive in cell C5.

When a case has been pulled from me or is no longer in active status I want to have it displace INACTIVE in the cell C5 based on their being a date in Cell P5

However when a case has been marked as closed there will be a date in Cell O5 and P5 will be blank

Hopefully this makes sense.

[Alaskan_grunt]

Maybe this will help clear up some confusion.

I need to write an "if" statement in Excel based on text in two different cells.

If O5 has a date then the text in Cell C5 will display CLOSED
If P5 has a date then the text in Cell C5 will display INACTIVE
If neither O5 or P5 has a date in it then cell C5 will display a total day counter based on a calculation of today's date and the date that is entered into cell H5

[Sam Capricci]

I think this covers what you want...
=IF(AND(O5<>"",P5<>""),H5,IF(AND(O5<>"",P5=""),"CLOSED","INACTIVE"))
though I am not sure what you mean here...

C5 will display a total day counter based on a calculation of today's date and the date that is entered into cell H5

[Alaskan_grunt]

Sambo Kid,

I need to display a counter in cell C5. So if I enter a date that I got the case in Cell H5 and that date was 08/31/2018 and todays date is 09/02/2018 then the counter would display 2 days.

See the original formula above.

[Alaskan_grunt]

I think this covers what you want...
=IF(AND(O5<>"",P5<>""),H5,IF(AND(O5<>"",P5=""),"CLOSED","INACTIVE"))
though I am not sure what you mean here...

Here is the original formula that I have been using.

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.

[Alaskan_grunt]

This worked perfect. Thank you very much!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.