Invoice Pay Schedule?

Hello,

I'm unsure of what I need to do when it comes to making if statements with multiple dates and variables. In the workbook I've attached I need to try and find a way to calculate the pay date from the creation and due dates. If the creation date is before the due date, I need a formula that takes the due date and uses that date to calculate when the person is going to be paid. If the creation date is after the due date the formula also has to take that into account. The only catch is that I was given a pdf that has a pay schedule with different dates that Sandy666 put into a workbook. (Thank you!) This pay schedule can change a pay date by a couple weeks depending on what day the entry was created, or when it is due.

Thank you!

Welcome to the forum!

Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, click Go Advanced below the text edit window, scroll down and click the Manage Attachments link, browse to the required file, and then push the Upload button, then Close Window to return to your post. (The "paper clip" icon for attachments is not currently working.)

Welcome to the forum,Please provide excel sheet not imges. For better help

please show your expected result for some dates