i was wondering if i can put name into a drop down box then get different date outcomes from different names... such as if sue is selected in the drop down menu then B1(a date i insert myself + 14 days)... ive got the drop down box already and know how to get the auto date (=B1+14) just dont know how to change it for different variables in the drop down box... i hope this is a challenge to some of u lol...