WORKDAY function

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!

For the first part I think you'd need VBA, not really my area of expertise but I'm sure somebody else can point you in the right direction......

For the second part you could use the WORKDAY function which excludes weekends, i.e. in C1

=IF(WORKDAY(B1,A1)<TODAY(),"Not OK","OK")

Note: Workday function is aprt of Analysis ToolPak add-in. If you don't have that installed try:

Tools > Add-ins > Tick "Analysis ToolPak" box

You guys are great! Thanks.. And sorry for not reading the rules.. I will go through them!

I'll see what I can do to figure this one out with the info above and let you know. Thanks