Skip to main content
Question

Checkbox Formula to Identify 3 Banking Days

  • September 1, 2020
  • 0 replies
  • 58 views

Good Morning, 

I am stuck on trying to create a formula where if two separate dates are within 5 calendar days within each other, that they would place a check in a checkbox. I assume it is a using checkbox-formula field. 

Better yet, is there a way to make Quickbase recognize 3 business days instead of just calendar days? For example; it does not include Saturday, Sundays, or Holidays. 

More of an example, Memorial day this year was Monday, May 25th, 2020. If the first date is May 21st, and the second date is May 27th, it would recognize that this is only 3 business days since we had the weekend + a holiday. 

If not, Just taking the 5 calendar days would be a huge help as described above. Any help on this would be greatly appreciated.  :)

------------------------------
Dale Miller
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Are these fields on the same record?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------