Sending weekly reminder sharepoint designer workflow

Question

Hi.

I am trying to create a weekly reminder email using sharepoint list and designer workflow. I have tried using this : https://threewill.com/sending-reminder-emails-using-sharepoint-designer-workflows

I have created both the lists as mentioned in the site. For the column in listA- the "NextReminderTime" column has the forumla
as :

=DATE(YEAR(LastReminderTime),IF(DAY(LastReminderTime)>6,MONTH(LastReminderTime)+1,MONTH(LastReminderTime)),7)

I want this workflow to be trigerred on every monday.
LastReminderTime in List A has - 7/26/2021

NextReminderTime in List A is showing as : 8/7/2021

The NextReminderTime should be 8/1/2021 . what should be fixed in the calculated column?

Answer 1

@Padmanabhan, Venkatesh ,

Change the calcualted column as shown below:

IF(WEEKDAY(LastReminderTime)<2,LastReminderTime+(2-WEEKDAY(LastReminderTime)),LastReminderTime+9-WEEKDAY(LastReminderTime))  

My test result for your reference:

---

If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.