Checking Dates
![denisewest](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
How do I write a formula that would look at a date field that is formatting dd/mm/yy and count if both the current month and the current year match. Then I would also want to do a count for the prior month, so if the month and year of that date matched those of last month, and we also have to account for the fact that Dec (12 ) comes before Jan (1). These are continually stumping me.
Answers
-
Just to be sure. Your speaking from a Fiscal year standpoint. You would have to create a reference sheet that to set the months of your fiscal year. then you could use a combination of Countif and Index Collect to achieve everything you need.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!