Increasing date

Desertbird

Hello,

I am trying to make columns that show each Monday based off of a Start Date. If the start date is 9/13/2021, the next one should be 9/20/2021, and the next column 9/27/2021.

I had a formula that was working just fine until it stopped for some reason: =Start Date + 7*(week #)

I'm not sure why that formula stopped working but is there another one that will work as well?

Paul Newcome

Did it start giving an error or was it outputting the wrong dates?

Desertbird

It's adding the 7*week # at the end, such as 9/20/202114, both are formatted as a date

Paul Newcome

How is the current date column being populated? It sounds as if either the column got switched to a text/number type or that the dates are being stored as text.

Desertbird

The original is being pulled via VLookup. However, the sheet it is pulling from I do not have access to change the column (can ask but will need a workaround until then).

Desertbird

I tried adding a helper column with this function but it came up invalid value.

=date(value(left([Date on new team]@row,2)),value(mid([Date on new team]@row,3,2)),value(right([Date on new team]@row,2)))

Paul Newcome

There are a couple of problems with the formula above. Will months and days always be two digits?

01/01/21

or could they be a single digit?

1/1/21

Exactly how is the date laid out?

mm/dd/yy

mm/dd/yyyy

dd/mm/yy

dd/mm/yyyy

The way you have your formula written, your date would end up looking more like this...

yy/mm/dd