bullock2270
New Member
- Joined
- Jan 5, 2014
- Messages
- 3
1=No, 0=Yes | |||||||
Day | Date | Status | OPEN | BOL # | Invoice TTL | Draft Date | Add Days |
Monday | 1/1/18 | N | 1 | 1/11/18 | 0 | ||
Tuesday | 1/2/18 | Y | 0 | 1/12/18 | 0 | ||
Wednesday | 1/3/18 | Y | 0 | 1/13/18 | 1 | ||
Thursday | 1/4/18 | Y | 0 | 1/14/18 | 1 | ||
Friday | 1/5/18 | Y | 0 | 1/15/18 | 1 | ||
Saturday | 1/6/18 | N | 1 | 1/16/18 | 0 | ||
Sunday | 1/7/18 | N | 1 | 1/17/18 | 0 | ||
Monday | 1/8/18 | Y | 0 | 1/18/18 | 0 |
<tbody>
</tbody>
I am attempting to build a spreadsheet that would predict ACH Date (10 Day Terms) but with respect to banking holidays and weekend days. For example: an invoice date of 1/3/18 would normally result in an ACH on 1/13/18; however, i will not draft until 1/16 as the bank is closed SAT,SUN & MON due to weekend and banking holiday back to back. I have applied a value of 1 if closed on a date and a 0 if open. Im trying to craft a formula that will use the calculated ACH date if adjacent cell =0, however, I also need the formula to continue to add a draft date for each consecutive day until it arrives at the next next day bank is open. Thanks for any assistance.