Adding 1 day to date in an If formula

Jen Frost

Hello.

I am trying to add one day to a date if the row meets a certain condition.

Instead of adding the day, it is putting a "1" at the end of the date string. I have confirmed both the original date and the column with the formula are formatted for date.

What else am I missing?

Leibel S

@Jen Frost

What is the formula in the Last Show Origin column.

It seems like the way it is pulling the date it is converting it to text.

Jen Frost

@Leibel S I think you're right. The formula in Last Show Origin is a link to a master sheet. On the master sheer I had to do a pull right formula to break the date out of the format I receive it in.

Is there a better way to break up the dates so they format correctly on the master sheet?

Leibel S

@Jen Frost

This will get complicated fast... Can you make that formula pull the date from the source?

Jen Frost

I could, but the problem is the original source is in text format "Thu 8/5/2021  -  Sun 8/8/2021" so I've got to figure out how to convert that to dates first. In excel I would use text to columns?

Leibel S

@Jen Frost

Try the below formula to convert it to a real date.

=DATE(VALUE(RIGHT(dates4, 4)), VALUE(SUBSTITUTE(LEFT(MID(dates4, FIND("-", dates4) + 7, 2), 2), "/", "")), VALUE(SUBSTITUTE(LEFT(MID(dates4, FIND("-", dates4) + 9, 2), 2), "/", "")))