Hello,

This is quite an awkward problem to describe, but bear with me...

I have a spreadsheet, including 2 columns. Let's say column A has the header Priority, and Column B has the header Due Date.

The user will assign an initial numeric value to Priority and assign a Due Date, for a given project. A higher number in the Priority column indicates a higher priority.

This is where the complication comes. Is there a way to increase the value in the Priority box by, say 50, for every week closer to the Due Date we get, based on the date today.

I don't know whether this needs to be VBA or if there is just a simple formula you can enter into a cell. Either way, I'm stumped.

Thanks in advance.