Predict Date of Enlistment

[Dave]

Soldier entry is done... my apologies for axing your code again. I leave the rest to you. If U enter the soldier number enquiry, U need to find the sheet (regiment), then the battalion and then search for the soldier number to see if it exists. If it does, show the date of enlistment. If it doesn't show the dates of the enlistment number before the soldier number and the date of the enlistment number after the soldier number. There is no accuracy prediction. HTH. Dave