#### Yodelayheewho

##### Member

I have two calculation challenges.

1. I've been searching and testing codes to calculate a promise date. The equation is PO received date + soonest lead time expressed in weeks = promise date.

txtLT = Lead Time and is formatted like this: 12 - 14 WKS

txtPORec'd = Date (ex: 01/02/2022)

txtPromDate = Date + the first two digits of the Lead Time (ex: 01/02/2022 + 12 weeks = 03/27/2022)

2. I also need to calculate an expiration date. The equation is proposal date + 60 expressed in days = expiration date

I found this example of the DataAdd function, but what I need isn't this straightforward. The following does not reference specific textbox values

Code:

`dFutureDate=DateAdd("d",60,"mm/dd/yyyy")`