add 7 days to a date

Renea

I need to add 7 days to a date, but not in a date column as i need to have a formula below for weeks increasing. the date needs to be Australian format i.e day/month/year.

Nick Korna

Not entirely sure this is easily doable, but as an alternative why not have your Primary column rows as the column headers instead?

That way you would be able to have a date column for the date and an easy formula to drag down to increase by 7 days, along with a WEEKNUMBER formula in the next column to calculate from same.

Andrée Starå

Hi @Renea

I hope you're well and safe!

I just did something similar for one of my clients.

In short, this is my structure. (you can add a week row to the structure)

Add a so-called helper row for YEAR, MONTH, and DAY.

The Date row combines the above to a date.

Then, in the following columns, you'd use something like this.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!