Excel Days of the Week

[mysti0014]

I have a file that calculates a due date for an invoice. I am trying to determine their expected pay date. There are some customers that would pay on Monday, some Tuesday, etc. I would like to make my formula return the day of the week that is specified for their payment. For example. If an invoice is dated 10/1/21, and is due 11/1/21 but they are expected to pay on the next Thursday I would like it to return 11/4/21 as the date. I would like to be able to use the same formula is the customer usually pays on Tuesdays. Invoice date of 10/1/21, due 11/1/21, and returns an 11/2/21 date.

 

[jasonb75]

You can use this formula, where A2 contains the due date.

=WORKDAY.INTL(A2-1,1,"1110111")

The 0 in the string at the end represents the payment day with the 7 digits being the days from Monday to Sunday, so "0111111" for Monday, "1110111" for Thursday, etc.