Add 3 months to date but not land on a weekend
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
------------------------------
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
------------------------------
- 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
------------------------------
