Forum Discussion
Invoice Pay Dates?
So I'm trying to figure out a formula for invoice pay periods. Attached is the pay schedule I have been tasked with using, and an excerpt from the spreadsheet I need to place the formula in. I need t...
Hey Josh-
You could use a logical formula to figure out the pay date. Not sure how you are calcualting the pay date based off of either column A or B. Do you have some kind of rule? Like pay at the beginning of next week or pay after 30 days? or something like that?
I have attached an example that uses the logic to pay after 30 days.... this can be modified to fit your specific rule. I just need to know what it is...