Date Formula Issues

[nickp20]

Excel version 16

Rows 5 & 6
Sent to consultant column "T" has no formula, its data manual date entry only
Required back column "U" =IF(T5="","",T5+15)
TODAY column "V" is usually hidden =TODAY()
Days Out Column "W" =IF(T5="","",U5-V5) also has conditional formatting changes the color of text green prior to the due date after the due text is red.
Received from Consultants column "X" has no formula, its data manual date entry.

The goal here is when we populate a date into the "Received from Consultant" column "X" we would like "Days Out" Column to be blank

 

[alansidman]

Here is a worksheet Change Event

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim tRow As Long
    If Target.Column = 24 Then
        tRow = Target.Row
        Range("W" & tRow) = ""
    End If

End Sub

In the VBE, click on the Sheet in the left window. When the right window opens, paste this code. Close and Save. Whenever you update Column X then Column W will become blank.

 

[jasonb75]

Try

=IF(OR(T5="",X5<>""),"",U5-V5)

 

[nickp20]

Formula works great as does the VBE code. Thank you for your help!!!