Calcuulate date based on weekday

[mushi4ka]

Hello,

I need to calculate a date. Here is an example:

Start date of employee is 2023-05-03. The previous Monday, an email should be sent to the employee.

How can I calculate the date based on the weekday.

I have a formula, but it only works if employee starts on a Monday

Cheers

[mushi4ka]

This is my formula:

DATETIME_FORMAT(DATEADD({Start Date}, -7, 'days'), 'YYYY-MM-DD')

[Jason_Hill]

DATETIME_FORMAT(DATEADD({hire date}, 0 - MOD(DATETIME_DIFF({hire date}, '2022-05-08', 'days'), 7) + 1, 'days'), 'M/D/YYYY')

[mushi4ka · Accepted solution]

We found this as a solution:

dateadd({Start Date}, (-6-WEEKDAY({Start Date})), 'days')