Due Date ouput to be static

[nikesone]

http://www.mrexcel.com/forum/showthr...=1#post1689353

Hi,

I wanted to make the Due Date output static, so it doesn't change the very next day when the value changes under Priority dropdown of URGENT, HIGH, and LOW. I know there's a vb macro or something that's been posted here, but i can't seem to even understand how to edit nor apply them to work with my worksheet. Below is a sample of the worksheet. Thank you very much in advance!

{=(TODAY())+SMALL(IF(WEEKDAY((TODAY())-1+ROW(INDIRECT("1:"&(VLOOKUP((B3),{"Urgent",1;"High",14;"Low",21},2,0))+ROUND(30*((VLOOKUP((B3),{"Urgent",1;"High",14;"Low",21},2,0))/30),0))))<6,ROW(INDIRECT("1:"&(VLOOKUP((B3),{"Urgent",1;"High",14;"Low",21},2,0))+ROUND(30*((VLOOKUP((B3),{"Urgent",1;"High",14;"Low",21},2,0))/30),0)))),(VLOOKUP((B3),{"Urgent",1;"High",14;"Low",21},2,0)))}

___A________B
1
2 Due Date Priority
3 09/19/08 URGENT
4 10/08/08 HIGH
5 10/17/08 LOW