Results 1 to 9 of 9

Return 1 or 0 based on Date Range

Threaded View

  1. #1
    Registered User
    Join Date
    03-02-2011
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Lightbulb Return 1 or 0 based on Date Range

    I need a function that will give a 1 if a range covers a month and a 0 if it does not. The entire month does not need to be covered by the range, just a single day, to return a 1.

    Here is what I have (short version) the full list goes through 2014:

    start 5/23/07
    end 9/20/07

    The result should be this:
    2007
    January 0
    February 0
    March 0
    April 0
    May 1
    June 1
    July 1
    August 1
    September 1
    October 0
    November 0
    December 0
    Attached Files Attached Files
    Last edited by kwjoh; 03-07-2011 at 01:39 PM.

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