Okay this is a simplified example of what I'm trying to do...<br><br>A1=Date of signature<br>B1=Version Date<br>C1=Correct Version Y/N?<br><br>In a separate worksheet called 'versions' I have....<br>D1=Document version (also a date)<br>E1=Effective Date<br>F1=Expired Date<br><br>Essentially I want excel to automatically determine if an individual signed the correct version of a document based on the effective and expired dates in the 2nd worksheet 'versions'. <br>First I want it to determine the correct version date (D1) based on comparing the date of signature (A1) to the range of dates (E1 & F1) associated with a particular version. THEN I want it to compare what that correct version (D1) should be to what was actually used (B1) and input a yes or no into C1. <br><br>I hope this makes sense. Thanks in advance for your help!!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Help with formula
- Thread starter aswan
- Start date
Similar threads
- Question
