Date Formula Issues

nickp20

New Member
Joined
Jun 24, 2020
Messages
6
Office Version
  1. 2016
Platform
  1. Windows
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.
Annotation 2020-06-24.PNG


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
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
5,926
Office Version
  1. 2019
Platform
  1. Windows
Here is a worksheet Change Event
VBA Code:
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.
 

nickp20

New Member
Joined
Jun 24, 2020
Messages
6
Office Version
  1. 2016
Platform
  1. Windows
Formula works great as does the VBE code. Thank you for your help!!!
 

Watch MrExcel Video

Forum statistics

Threads
1,113,875
Messages
5,544,808
Members
410,635
Latest member
phoenix7771
Top