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

Question

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

markshnier__you · Answer

Is this the mapping you want?Monday -&gt; WednesdayTuesday -&gt; WednesdayWednesday -&gt; WednesdayThursday, Friday, Saturday, Sunday&nbsp; -&gt; the next Wednesday------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

courtneylaw · Answer

Correct!------------------------------Courtney Law------------------------------

markshnier__you · Answer

OK, try thisvar number DaysToAdd = Case(DayOfWeek([My Date Field]),1,2,2,1,3,0,4,6,5,5,6,4,0,3);[My Date Field] + Days($DaysToAdd)------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

courtneylaw · Answer

This formula seems to be working. Thank you very much!------------------------------Courtney Law------------------------------

Forum Discussion

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

4 Replies