Counting days between two dates but stopping the count on a third date

[Lifsgd]

Column A is a date a ticket is opened
Column B is today’s date
Column C counts the days between A & B
Column D is the date the ticket is closed

I want column C to count the days between A & B, which it currently does using
=DAYS([@[Today”a Date]],[@[Date Opened]])

but I want the days in column C to stop counting and hold the value when a date is put in column D

Please help with the formula!

 

[GR00007]

If B is to be today all the time you don't need that column, you could use Today().
Give this a try:

=DAYS(IF(IF(D2="",999999,D2) < B2,D2,B2), A2)

<b2,d2,b2),a2)[ code]

Column B is replaced by column D value if there is an entry and the entry is less than B's value<b2,d2,b2),a2)[ code]<="" html=""></b2,d2,b2),a2)[></b2,d2,b2),a2)[>

 

[JrayK2]

or you could do

=IF(D2="",Now()-A2,D2-A2) or =IF(D2="",B2-A2,D2-A2)

 

[Lifsgd]

If I deleted column B where would I put today() in the formula? Sorry, I’m new at this

 

[JrayK2]

If you deleted column B use:

=IF(C2="",Now()-A2,C2-A2