+ Reply to Thread
Results 1 to 3 of 3

Formula to assign specific numbers if a date falls within a certain date range

  1. #1
    Registered User
    Join Date
    12-04-2010
    Location
    Jamaica
    MS-Off Ver
    Excel 2003
    Posts
    92

    Formula to assign specific numbers if a date falls within a certain date range

    Hello Experts,
    I need help in writing a formula that would return a specific number into a blank cell based on a date that is inputted in a certain cell.

    Example any date in July ( ie: Jul 1- 31) that is inputted in let say cell A5, i want the number 1 to be returned in cell B5. Any date in August that is inputted in cell A5 the formula should return 2, etc. Please see Month and period number below.


    Jul = Period 1
    Aug = Period 2
    Sep = Period 3
    Oct = Period 4
    Nov = Period 5
    Dec = Period 6
    Jan = Period 7
    Feb = Period 8
    Mar = Period 9
    Apr = Period 10
    May = Period 11
    Jun = Period 12


    Thanks,
    HB

  2. #2
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    604

    Re: Formula to assign specific numbers if a date falls within a certain date range

    See "BLUE" attached.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    12-04-2010
    Location
    Jamaica
    MS-Off Ver
    Excel 2003
    Posts
    92

    Re: Formula to assign specific numbers if a date falls within a certain date range

    Thanks ..... The formula works ok.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 07-14-2017, 12:04 PM
  2. Replies: 4
    Last Post: 06-18-2013, 08:17 PM
  3. Replies: 15
    Last Post: 04-08-2013, 12:40 PM
  4. Mark cell if location matches and date falls between date range
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-24-2012, 07:54 PM
  5. Replies: 4
    Last Post: 02-18-2009, 09:21 AM

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