Results 1 to 6 of 6

IF statement together with a couple of functions

Threaded View

  1. #1
    Registered User
    Join Date
    04-20-2011
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2013
    Posts
    54

    Lightbulb IF statement together with a couple of functions

    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.
    Attached Files Attached Files
    Last edited by Kagesen; 04-24-2011 at 02:25 AM. Reason: Attached excel file

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1