hey I am wanting to list the dates say from 20th march and so on down the page in a single column
like so
Answers
-
Hi, @aaron tuheke.
Here's one way to do it.
In your DAY of WEEK column, use this formula.
=IF(WEEKDAY([Appt Date]@row) = 1, "Sunday", IF(WEEKDAY([Appt Date]@row) = 2, "Monday", IF(WEEKDAY([Appt Date]@row) = 3, "Tuesday", IF(WEEKDAY([Appt Date]@row) = 4, "Wednesday", IF(WEEKDAY([Appt Date]@row) = 5, "Thursday", IF(WEEKDAY([Appt Date]@row) = 6, "Friday", IF(WEEKDAY([Appt Date]@row) = 7, "Saturday")))))))
After you've input the formula, right click on one occurrence of the working formula and choose "Convert to Column Formula." This will autoapply the formula to all rows in the DAY of WEEK column and will show a day of week where a date is added in the referenced date field.
Then, in your date field, you can select 3 or more consecutive dates, grab the lower right corner of the box, and drag down to autofill to the end of your range.
Should you want or need to modify the formula in the DAY of WEEK, you would need to right click a cell that holds the formula and choose either Edit Column Formula or Convert to Cell Value to edit conventionally.
Give it a try and let me know if it helps.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!