+ Reply to Thread
Results 1 to 3 of 3

Converting a date to a specific numeric value.

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Converting a date to a specific numeric value.

    I want to change a date, 3-Jan-12 (format), to a table reference so that any date in each particular month will arrive at the corresponding number adjacent to it in the table shown below. For example, 3-Jan-12 = 0, 4-Feb-12 = 1 and so on. The table below is on a separate sheet called arrays, with the data in rows L and M respecively. The original date is in cell D2 and continues down column D. Can anyone assist? Even if the outcome is provided on as a single sheet reference I can update the other sheet name ok.

    Month Month_Value
    January 0
    February 1
    March 2
    April 3
    May 4
    June 5
    July 6
    August 7
    September 8
    October 9
    November 10
    December 11
    Last edited by Christopherdj; 05-25-2012 at 12:09 PM.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Converting a date to a specific numeric value.

    if the months are in order you can use
    =index('other sheet'!$B$2:$B$12,month(D2))
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Re: Converting a date to a specific numeric value.

    Thanks for the help, I didn't think about index..... working fine.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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