Need a check mark for rows added last month
I want a checkmark to appear when entries were created the previous month. i.e., all April entries would have a checkmark, and starting June 1, only May entries, and so on. I thought the following formula was a good place to begin, but apparently the -1 is only subtracting a day, not a month. =IF(MONTH([Entry Date]@row) = MONTH(TODAY(-1)), 1)
Please advise. Thank you!
Answers
-
That won't work ;-) The function TODAY(-1) will give you yesterday's date, so it has to be MONTH(TODAY())-1for last month
Try the below, (I have factored in the year too as considering only month will give you incorrect results when you have entries from past or next year)
=IFERROR(IF(MONTH(TODAY()) <> 1, IF(AND( (MONTH(TODAY()) - MONTH([Entry Date]@row) = 1), (YEAR(TODAY()) = YEAR([Entry Date]@row)) ), 1, 0), IF(AND( (YEAR(TODAY()) - YEAR([Entry Date]@row) = 1), (MONTH([Entry Date]@row) = 12) ), 1, 0)), 0)
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!