xl down Question

[jamesmev]

I have a data set where the rows will vary based on that information pulled.
However, I am needing make an adjustment to one of the Columns based on the date.
I have the Formula as "=IFS(RC[-19]<=TODAY(),TODAY()+2,RC[-19]>TODAY(),RC[-19])"

How Do I apply that formula to that Column Down?

Example:
Anything on "I" if the date is either earlier than 2 days from today adjust the date to 2 days from today.
If It is after 2 days from today keep the date on that column.


I feel like I am making harder than it is which is causing a lot of issues.

Please any help would be appreciated.

 

[Fluff]

Which column are you putting that formula in & what is the 1st row?

 

[jamesmev]

Which column are you putting that formula in & what is the 1st row?

The goal would be for it to overwrite what is in I starting with I2. If it can not just automatically overwrite the data in I it would then be moved to AB2 XlDown copied from AB2 back to I2 XlDown

 

[Fluff]

Ok, how about

Sub jamesmev()
   With Range("I2", Range("I" & Rows.count).End(xlUp))
      .Value = Evaluate(Replace("if(@<=Today(),today()+2,@)", "@", .Address))
   End With
End Sub

 

[jamesmev]

With Range("I2", Range("I" & Rows.count).End(xlUp)) .Value = Evaluate(Replace("if(@<=Today(),today()+2,@)", "@", .Address)) End With

It seems to work - However, it only works if/when I double click into the cell then click out.
I have Calculations as automatic.

 

[Fluff]

I don't understand what you mean. Double-clicking a cell does not run that macro.

 

[jamesmev]

I don't understand what you mean. Double-clicking a cell does not run that macro.

When I double click the cell then run the macro it works.
I'm unsure the cause

 

[Fluff]

That suggests that your dates are not real dates, but text.

 

[jamesmev]

That suggests that your dates are not real dates, but text.

Thank you. I was able to solve!

 

[Fluff]

Glad you sorted it & thanks for the feedback.