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
------------------------------
Question
Formula Help Needed - Round a date to a specific day of the week
This topic has been closed for replies.
+22Is 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
------------------------------
Monday -> Wednesday
Tuesday -> Wednesday
Wednesday -> Wednesday
Thursday, Friday, Saturday, Sunday -> the next Wednesday
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.