Okay - so I am not too hip on excel and am having troubles with what I am needing to do. My boss has tasked me to fix the work order log we use, and since he has complicated things, it needs modified.

Basically we list jobs that we do as a Priority 1 through 4.

We then list the date that we received the work order, the due date, and the date completed.

The only boxes I am concerned with are the priority, date received and date due.

The Priority box is a drop down menu.... and obviously the options are 1, 2, 3 and 4.

The date received box is formatted as follows - 2009-02-02 (for example).

The date due depends on the priority.

Priority 1 = 1 days
Priority 2 = 3 days
Prioirty 3 = 10 days
Priority 4 = 14 days

Priority is in column B, Date Received is in column E, and date due is in column F.

I'd like the date due to be automatically filled in depending on the priority and date received.

If you need more information to assist with this, or have other suggestions to what may work, please let me know. This has my brain scrambled.