MikeMike
7 years agoQrew Cadet
Calculate date after 7 business days
Our customers pay us on a set date each month via autopay through our payment processor. Our payment processor sends the money to us 7 business days later.
We have a column in Quick Base that records the set date using just the day of month eg. 1 if they pay on the 1st of every month, 10 if they pay on 10th of every month.
What I want to produce now is two columns, one that tells me for the current month when to expect the deposit from the payment processor, and then one that tells me for the next month.
The problem is weekends and holidays. For example this month the 1st was a Saturday (not a business day) and then the Monday was a holiday (not a business day) so day 1 of the 7 was the 4th, so expected deposit date is the 12th.
Is it possible to automatically show this expected date based on working days? Current month is the priority, but if another field can do next month as well then that's a bonus.
We have a column in Quick Base that records the set date using just the day of month eg. 1 if they pay on the 1st of every month, 10 if they pay on 10th of every month.
What I want to produce now is two columns, one that tells me for the current month when to expect the deposit from the payment processor, and then one that tells me for the next month.
The problem is weekends and holidays. For example this month the 1st was a Saturday (not a business day) and then the Monday was a holiday (not a business day) so day 1 of the 7 was the 4th, so expected deposit date is the 12th.
Is it possible to automatically show this expected date based on working days? Current month is the priority, but if another field can do next month as well then that's a bonus.