Hi.

This is my first vba task. What i need to do is, calculate end date based on the start date and number of days.

I have the values for start date in column A and duration i.e.; number of days in column B. Calculating business days is my second concern as of now. What I first need to know is, how can i use Worksheet_Change event?

What i thought of doing is, when user enters duration in any cell in column A say A(n), Cell B(n) gets selected in the Worksheet_Change event code. And when Start Date is entered in B2, function to calculate End date is called. Please let me know if its a correct approach or not.

Also what caused trouble for me was, when I press Enter key after entering values in cells, the Worksheet event behaves abruptly.

Please help me solve this simple yet complex issue for me!