Having calendar view pull from today's date

Created a report to reflect the calendar view of a sheet and the oldest date is being shown instead of today's date. How can I make the today date be the default?
I added the following formula into the sheet but isn't working: =DATE(YEAR(TODAY()), MONTH(TODAY()), 1)
Answers
-
Unfortunately Gantt view is the only one that has the option to "Open to Today's Date".
Feel free to browse the product enhancement request area to see if someone else has submitted the idea to include this option in Calendar view. If they have, you can vote on it. If they have not, you can submit the idea yourself which will allow others to vote on it. You can also provide the link to the request here on this thread so anyone else looking for the same thing can quickly vote on it as well.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.2K Get Help
- 452 Global Discussions
- 155 Industry Talk
- 505 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 514 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!