Auto-Number the next column within one row
Hello,
I have created a sheet that I will use to track scheduling in Construction. I have attached 2 photos. I want to have an automated number/date system like the excel picture shows. Can anyone assist in what formula or strategy I need to implement?
Thank You
Answers
-
Where are your dates? Have you looked into Gantt view?
-
I have but my dates will change regularly. To provide more insight, this is something that I will be saving as a pdf to send out on a weekly basis and the numbers in the top row will change each week to reflect the day of the month. For instance, I have attached a screen snip of what I would like to be automated. I achieved this by setting M1 as the 7th and went to each individual cell and did =m1+1 and so on. Next week when I do it, it will start with 14 and continue from there. I can change it every week but would like to save myself some time and learn a new trick if possible. One of the snags with my system is when I get to the end of the month and need to start at 1.
-
See other comment
-
What determines which cells get highlighted?
-
That is only to differentiate the weeks. I am only concerned about the numbers
-
Do you have a starting date (similar to your excel screenshot), or is it some kind of logic based on today's date such as first column is always current Monday? If it is "current Monday", how do you handle if today is a Saturday or Sunday? Would you want it to show the previous Monday or the upcoming Monday?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 434 Global Discussions
- 136 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 485 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
