We have recurring expenses that are due on certain days of the year. If the payment date falls on a weekend or holiday the payment will occur on the next business day after the weekend or holiday. I need a formula that will sum all payments due for a certain day of the year that will conform to the rules above. Please see attached example.
21 freelancers are bidding on average $49 for this job
Hello, I am specialist in MS Excel, VBA and scripts. Working on formulas like this is my job and my hobby. Hiring me is the right decision. :) Please check PM