Hi to all excel guru's in here :-)
I have a real headache thinking about how I can come up with a genious formula to improve/streamline my excel sheet.
In the attachment you will see my setup. What is important to focus on is column F. The information listed in column F is the date when a specific persons crane certificate expires. For example cell F3 shows that Domingo N General's Hydralift certificate expires on the 18.06.2012.
What I would like to have set up is a system that automatically picks out those certificates that expire within 3 months or have expired. This system will be able to provide me with valuable information because I can better plan refresher training so no certificates expire. In an ideal world the system should assist me in better planning, minimize human errors which in return means more time for other tasks.
I hope there is an extremely talented excel individual out there who can help me with my query. What I have thought of so far is to use the IF statement together with LOOKUP but I just dont know how to do the DATE thing.
Thank you in advance.
Bookmarks