I would like to learn how to calculate leadtime in VBA. I have a txtbox that has a date. Formatted as date. I have a txtbox that has a number. I have another box that is a calculation of the two. Example
needs to equal 10 weeks in the future starting on 10/29/08.
I have a work around adding another txtbox4. which is calculated as =txtbx2*7. Then
txtbx3 is calculated as =txtbx1*txtbx4.
There has to be another way. This question is strictly for learning and not any emergency. It would be nice to learn a new trick