Checkbox Formula to Identify 3 Banking Days
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
------------------------------
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
------------------------------
