+ Reply to Thread
Results 1 to 5 of 5

Need Formula that will show 'Month" for date that fall in the particular month

  1. 12-28-2014, 01:27 PM #1
    JESSHOR60
    JESSHOR60 is offline
    Registered User
    Join Date
    12-28-2014
    Location
    Malaysia
    MS-Off Ver
    Professional 2007
    Posts
    21

    Need Formula that will show 'Month" for date that fall in the particular month

    Need Help - Need Formula that will show 'Month" for date that fall in the particular month. Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-28-2014, 01:32 PM #2
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Need Formula that will show 'Month" for date that fall in the particular month

    Try this one

    =TEXT(A5,"mmm")

    and copy down
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
  3. 12-28-2014, 01:35 PM #3
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Need Formula that will show 'Month" for date that fall in the particular month

    either just in e5
    =a5 custom format as mmm
    or if you just want the month in text format
    =TEXT(A5,"mmm")
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
  4. 12-28-2014, 01:36 PM #4
    JESSHOR60
    JESSHOR60 is offline
    Registered User
    Join Date
    12-28-2014
    Location
    Malaysia
    MS-Off Ver
    Professional 2007
    Posts
    21

    Re: Need Formula that will show 'Month" for date that fall in the particular month

    Thanks... Solved my problem.
    Reply With QuoteRegister To Reply
  5. 12-28-2014, 01:47 PM #5
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Need Formula that will show 'Month" for date that fall in the particular month

    thanks for the feedback,glad we could help
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How can i show date in this form (month,last date of that month, Year)?
    By vjharry in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-24-2014, 04:39 AM
  2. Month over Month formula to show increase or decrease in rankings for SEO
    By lindsbay in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-12-2014, 03:03 AM
  3. finding if 2 date fields fall within a particular month
    By lb0224 in forum Excel General
    Replies: 1
    Last Post: 12-03-2009, 01:42 PM
  4. Convert "Date" to week & month Month automatically
    By ajxxx in forum Excel General
    Replies: 7
    Last Post: 11-16-2008, 04:20 PM
  5. [SOLVED] RE: Function or formula to convert "text" month to number of month
    By Steve Vincent in forum Excel General
    Replies: 1
    Last Post: 02-04-2006, 12:19 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1