add 7 days to a date

Options

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.



Tags:

Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Options

    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å
    Andrée Starå ✭✭✭✭✭✭
    edited 12/04/23
    Options

    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!