A/R Aging Due Date

[PuckMark19]

I am trying to write a formula that will calculate Accounts Receivable due dates. Some of the due dates are easy, because a few of our customers have terms of Net 30, Net 45, etc. However, a handful of our customers have due dates that read: "2nd day / 2nd month". In other words, if the invoice date is 02/20/2018 (today), the due date would be 04/02/2018. Any invoice date during the month of February would have a due date of 04/02/2018, and then in March, the due date would be 05/02/2018. Is there an easy way to write this formula? I've tried a few different things, but have not been successful.

Thanks in advance.

 

[wideboydixon]

If the invoice date is in A1 then:

=DATE(YEAR(A1),MONTH(A1)+2,2)

WBD

 

[PuckMark19]

If the invoice date is in A1 then:

=DATE(YEAR(A1),MONTH(A1)+2,2)

WBD

Awesome - thank you so much.