add 7 days to a date
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.
Answers
-
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.
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!