Skip to main content
Solved

Add 3 months to date but not land on a weekend


Forum|alt.badge.img+20
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
------------------------------

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 original

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------