+ Reply to Thread
Results 1 to 11 of 11

how to return a day(number) by selecting month and year from data list

  1. #1
    Forum Contributor
    Join Date
    11-28-2011
    Location
    puerto rico
    MS-Off Ver
    Excel 2007
    Posts
    113

    how to return a day(number) by selecting month and year from data list

    hi everyone..
    i was wondering if any of you can help me.
    i am making an attendance rollbook for my classes. but i am having trouble with the formula.
    what i want is to have excel return the day as a number when i select from a data list the month and the year. i found a from that uses this formula for what i need =DATEVALUE(AC2&" 1, "&AC3)
    in that form i choose from a list the month in ac2 and write the year in ac3 but when i try to recreate the same thing in my own form it returns a value error. I have no idea what the 1 in that formula is for. i uploaded the form with the working formula for you to see.

    ill appreciate your help..
    merry christmas!
    Attached Files Attached Files
    Last edited by lizsantiago07; 12-24-2012 at 02:39 PM.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: how to return a day(number) by selecting month and year from data list

    The 1 is so you can establish the first day of the month.

    The best way to understand what the formula is doing is by using Evaluate formula.

    Click on the cell >> Ribbon >> Formulas >> Formula Auditing >> Evaluate Formula
    HTH
    Regards, Jeff

  3. #3
    Forum Contributor
    Join Date
    11-28-2011
    Location
    puerto rico
    MS-Off Ver
    Excel 2007
    Posts
    113

    Re: how to return a day(number) by selecting month and year from data list

    yes i did that but is not working anyway in my own form

  4. #4
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: how to return a day(number) by selecting month and year from data list

    Hi lizsantiago07

    Try in D7:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: how to return a day(number) by selecting month and year from data list

    Quote Originally Posted by lizsantiago07 View Post
    yes i did that but is not working anyway in my own form
    Kind of hard to help with your "own form" when the attachment you posted works.

    Maybe you need to provide us with what you are working with or at the least, provide us with what is in your cells that is making up the inputs to the formula?

  6. #6
    Forum Contributor
    Join Date
    11-28-2011
    Location
    puerto rico
    MS-Off Ver
    Excel 2007
    Posts
    113

    Re: how to return a day(number) by selecting month and year from data list

    thks kevin but it doesnt work either, i uploaded my form
    Attached Files Attached Files

  7. #7
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: how to return a day(number) by selecting month and year from data list

    Quote Originally Posted by lizsantiago07 View Post
    thks kevin but it doesnt work either, i uploaded my form
    Hic, Bill is American and his products must be in English.
    Try to type month in English.
    Quang PT

  8. #8
    Forum Contributor
    Join Date
    11-28-2011
    Location
    puerto rico
    MS-Off Ver
    Excel 2007
    Posts
    113

    Re: how to return a day(number) by selecting month and year from data list

    lol OMG!! that was it , i didnt noticed it was in spanish !!!! Im an idiot loooool thks bebo!

  9. #9
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: how to return a day(number) by selecting month and year from data list

    e8
    Please Login or Register  to view this content.
    it gives the result AGOSTO 2013

    Is this what you're up to?
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  10. #10
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: how to return a day(number) by selecting month and year from data list

    If you want to keep spanish, translate to English in C52:C61, then use this:
    Please Login or Register  to view this content.

  11. #11
    Forum Contributor
    Join Date
    11-28-2011
    Location
    puerto rico
    MS-Off Ver
    Excel 2007
    Posts
    113

    Re: how to return a day(number) by selecting month and year from data list

    thks a lot!!!!!!!!!!!!!!

+ 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