Okay I am trying to create a spreadsheet that will automatically populate some due date information. In C3 is the date received, D3 is a drop down box with the option of priority 1, priority 2, and priority 3. I need E3 to automatically populate the date it is due by based on the initial date and what s selected in D3, priority 1 needs to equal original date plus 1, priority 2 equals the original date plus 2 days, the priority 3 is plus three days, but weekend days are excluded in that calculation. I hope this makes sense![]()
Bookmarks