Results 1 to 5 of 5

Date Ranges and IF statements

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-22-2013
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    100

    Date Ranges and IF statements

    Hello --

    On a worksheet, in column E is a hire date and column F is a terminated date (row 2). Then columns G-BI are month/years.

    I want Row2 Column G-BI to answer the question if the individual as an employee in a given month/year with a Y or blank.

    How would I do this?

    Attached is an example of how the layout and what I'd want it to look like.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Confusing Logic Question Regarding IF statements and date ranges
    By rbac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2013, 03:45 PM
  2. Cell ranges and IF statements
    By stefan82 in forum Excel General
    Replies: 4
    Last Post: 04-24-2012, 07:00 PM
  3. If statements for ranges
    By garopro in forum Excel General
    Replies: 11
    Last Post: 09-29-2011, 11:33 AM
  4. Multiple If then Statements with ranges
    By cs1014 in forum Excel General
    Replies: 2
    Last Post: 07-29-2009, 12:21 PM
  5. IF statements and ranges
    By Idz21 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-22-2006, 05:22 PM

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