Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages

Excel month names

Tagged: 

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #13627 Reply
    Ian C
    Guest

    I need to be able to check each row in a spreadsheet that a date is entered into and check which month it is checked again a cell with at month number entered e.g. 6 for June etc. Does any one know how this can be done. I tried to use the Month formula but it does not seem to work on a range of cells, this is in Excel 97.

    Please Help

    #13628 Reply
    adi
    Guest

    U r right. month formula doesn’t work.
    Actually, I need the excel sheet.
    So that I can provide the solution.

    #13629 Reply
    Ian C
    Guest

    Hi Adi,

    Thanks for the reply whats ur e-mail and i’ll send you a copy of the spreadsheet.

    Regards

    Ian.

    #13630 Reply
    Adi
    Guest

    My email is syadarsh76@homail.com

    #13631 Reply
    uppchunk
    Guest

    Hi Ian,
    if date is enterered in column A then:
    =CHOOSE(MONTH(A1),”JAN”,”FEB”,”MAR”,”APR”,”MAY”,”JUN”,”JUL”,”AUG”,”SEP”,”OCT”,”NOV”,”DEC”)

    is this you looking for?

    #13632 Reply
    Ian C
    Guest

    Hi Uppchunk,

    Well your formula is good but not exactly what I was looking for. I need a formula that would look at the range of A:A and pick out each row that has say month 6(jun out and then do a sumif depending on another formula result.

    Thanks Anyway

    Ian C.

    #13633 Reply
    adi
    Guest

    Hi Ian,

    Recieved ur mail. I will get back to u.

    -adi

Viewing 7 posts - 1 through 7 (of 7 total)
Reply To: Excel month names
Your information:




<a href="" title="" rel="" target=""> <blockquote cite=""> <code> <pre class=""> <em> <strong> <del datetime="" cite=""> <ins datetime="" cite=""> <ul> <ol start=""> <li> <img src="" border="" alt="" height="" width="">