Jtdylktuy

0 I have a task log that I created at work to prioritize my daily to-do's. In one column I've added a formula to automatically calculate Covey's quadrant numbers based on whether or not I've assigned a task as urgent or not urgent and important or less important (which populates as 1 , 2 , 3 or 4 ). I also have a column to assign a due date. I want to automatically assign a due date and I wrote a formula to do so, but the TODAY function means that tomorrow, my due dates will change. Here is what I am looking to accomplish: I want the due date to calculate automatically based on the quadrant in column G and today's date. I want the due date to remain static when I open the workbook tomorrow. When I enter a new task tomorrow, I want the due date to automatically calculate again using th