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 |