IF Function

I have attached a worksheet that shows the last and first name of an employee along with their hire date and term date, if termed. What I am looking for is a function that will tell me if a person was active as of 12/31/08 which will read true on the side of their name under active; I also need a function that will tell me if a person worked over 6 months in 2008. Yesterday, I had a genius help me with another function for this sheet but I was hoping to add this function in another column.

The first person John Doe was hired in 2005 and has a true on the side of his name which meant that he was active as of 12/31/08 but as you can see Jane Doe has true on the side of her hire date and false on the side of her term date and I don't want it to read the first true but the last true of someones name, but Jane Doe qualifies for working over 6 months even though she started in 2007. If it gets complicated then I don't need to know if someone worked over 6 months from a carryover of another year, but it would be helpful if I can get the information for someone who has worked 6 months or more in 2008.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Not necessarily a better title but.....anyways.....

You say Jane Doe started in 2007, but your sheet shows she started in 2008 as far as I can see...

So what should the Active Cells results actually be? Are the TRUEs/FALSEs there the actual expected results?

This formula should return TRUE if either the date in column D is Before 12/31/08 or the date in D is later than 6 months ago (based on today's date). It will return FALSE if both conditions fail.

Please Login or Register  to view this content.

is that what you needed?

Originally Posted by Reenee

Are you still there?

Sorry...went to bed...

Try:

Please Login or Register  to view this content.

copied down.

Is that it?