Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Calcuulate date based on weekday

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
2197 3
cancel
Showing results for 
Search instead for 
Did you mean: 
mushi4ka
5 - Automation Enthusiast
5 - Automation Enthusiast

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
1 Solution

Accepted Solutions
mushi4ka
5 - Automation Enthusiast
5 - Automation Enthusiast

We found this as a solution:

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

See Solution in Thread

3 Replies 3
mushi4ka
5 - Automation Enthusiast
5 - Automation Enthusiast

This is my formula:

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

Jason_Hill
6 - Interface Innovator
6 - Interface Innovator

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

mushi4ka
5 - Automation Enthusiast
5 - Automation Enthusiast

We found this as a solution:

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