Hi Excel Genius,
I have a question. Here is what i am trying to do.
Sheet 1
A1 B1
Name Approval Date
Jason 12/15/2013
Bob 09/06/2013
Sheet 2
A1 B1 C1
Name Completed Date Comment
Jason 11/15/2013 Completed Date cannot be before after approval date
Bob 10/06/2013 Fine
Can anyone help with the formula? Basically, in sheet 1, all the names and when it was approved is there. In Sheet 2, it will look at sheet 1 approval date and corresponding name. If the completed date is after the approval date, it is fine. If it is before the approval date, it should give some kind of error message.
Can anyone help?
Thank you
Bookmarks