Hi,

I'm not new to Excel but now I have to create something I have not done before. It should be possible but I don't know how.. Anyone can help me out a little? Many thanks!

1st:
Anytime a value in cell A1 is modified, the value of cell B1 should be automagically filled with the current date + time.

2nd:
Cell A1 has 4 possible values (combobox): 1, 2, 3, 4 (days).
Cell B1 has a date as value
Cell C1 has a status as a value which should be calculated: ok, not-ok.

The status should be calculated as follows:
- If the current date minus the date from cell B1 is greater than the value of cell A1 then the value of cell C1 is 'not-ok'.
- If the current date minus the date from cell B1 is smaller than the value of cell A1 then the value of cell C1 is 'ok'.

To make it a bit more interesting for you guru's. As we are talking about dates here, it would be awesome if the formula also excludes weekends. So Mon-Fri = 1 and Sat-Sun = 0.

Basically I want to set a priority for executing a process at a planned date. The amount of days for the process to complete is based on the priority set.
I'm now able to see an overview of my planning with objects that are ok and objects that are not ok (days exceeded).

Many thanks!