Skip to main content
Question

Formula Help Needed - Round a date to a specific day of the week

  • Jun 13, 2022 5:46 PM UTC
  • 0 replies
  • 108 views

I am looking for a way to round a date field to a specific day of the week. I.e., my date falls on a Monday or a Friday, but I want the date field to show the upcoming Wednesday date. Any solutions?

------------------------------
Courtney Law
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Is this the mapping you want?
Monday -> Wednesday
Tuesday -> Wednesday
Wednesday -> Wednesday
Thursday, Friday, Saturday, Sunday  -> the next Wednesday

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------