Well, I thought I was done with this until the boss adds "Just one more thing". I guess he's stuck watching re-runs of Columbo! I have learned a great deal here at the forum and am now addicted to learning as much as I can about Excel and what it can accomplish. I know this task is possible, maybe even easy if you know which function to use. We are tracking attendance for employees and allow them to take a Perfect Attendance "PA" day for every 6 months they do not call in sick or late. Once they have earned the attendance day, it must be used within the following 6 month period or else they loose it. I have successfully calculated when the attendance day is earned and when it expires, but I would like to show when it was taken. In my attached sample, the first record should be returned as 6/13/13 as that falls within the "earned" and "expires" dates. The second record should be returned as 6/6/13. I've tried nesting a lookup function within a countifs function, but can not seem to get the syntax right, (I may not even be on the right path). My gut tells me I may need to dive into the Index / Match solution, but have yet to master that one too. I could track it manually, but it is less likely to get messed up by those I work with if it's automated. I'm trying not to turn to the forum for everything, but the more I learn, the more self sufficient I can become.
Once again, I thank you good people of the forum for sharing your knowledge and experience.
Scott
Bookmarks