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...
Forum Discussion
Yes, same record. This is how I have the fields on my form. And I am wanting the date of last strike versus the date of exception to be part of the formula.
Date of exception would be a later date then the date of last strike is.
------------------------------
Dale Miller
------------------------------
Date of exception would be a later date then the date of last strike is.
------------------------------
Dale Miller
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendThe formula for the number of business days between dates would be
WeekDaySub([later field date], [earlier field date])
That formula will skip weekends (but not holidays).
Note that if the first date was Sept 1, 2020 and then 2nd date was Sept 2, 2020, then the result will be 1. ie its not counting both ends of the range.
For a formula checkbox field you can try this
IF(WeekDaySub([later field date], [earlier field date]) <=5, true)
Holidays are tricky, and would probably require some one on one assistance.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
WeekDaySub([later field date], [earlier field date])
That formula will skip weekends (but not holidays).
Note that if the first date was Sept 1, 2020 and then 2nd date was Sept 2, 2020, then the result will be 1. ie its not counting both ends of the range.
For a formula checkbox field you can try this
IF(WeekDaySub([later field date], [earlier field date]) <=5, true)
Holidays are tricky, and would probably require some one on one assistance.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------