skip to Main Content

How to calculate the reminder date automatically and display the item based on the month & year of its reminder date (Part-2)

Part 2: Steps to display the item based on the month & year of its reminder date

1. ​Create 2 more columns with the steps in Part 1 (Step 1 – 5). Then, named the 2 columns as “​Reminder Start Month” and “Reminder End Month” with the formula:-

​Reminder Start Month (First day) ​Reminder End Month​ (Last day)
​=DATE(YEAR([ReminderDate]),MONTH([Reminder Date]),1) ​=DATE(YEAR([Reminder Date]),MONTH([Reminder Date])+1,1)-1
Read More