Skip to main content
Solved

Add 3 months to date but not land on a weekend

  • Jul 27, 2022 7:32 PM UTC
  • 0 replies
  • 81 views

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
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
  • Qrew Champion
  • Answer
  • Jul 27, 2022 8:02 PM UTC
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
------------------------------