Any thoughts of how to add 3 months to a date, but if it lands on a saturday or sunday, bounce forward to the monday, or bounce back to the friday?
My initial thought is to add the 3 months, check DayofWeek, then add or subtract a day if needed. Is there a better way?
------------------------------
Mike Tamoush
------------------------------
Solved
Add 3 months to date but not land on a weekend
Best answer by MarkShnierYou
np,
https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=153&rl=csi
WeekdayN(AdjustMonth([my date],3))
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
View originalhttps://login.quickbase.com/db/6ewwzuuj?a=dr&rid=153&rl=csi
WeekdayN(AdjustMonth([my date],3))
------------------------------
Mark Shnier (Your Quickbase Coach)
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.