Results 1 to 11 of 11

Reflect Month Name when Column A Date is the Same Day & Month

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    672

    Reflect Month Name when Column A Date is the Same Day & Month

    Dear friends,
    Please correct this formula to get correct output.

    =IF(P9=TODAY(),IF(P9<>"",CHOOSE(MONTH(P9),"January","February","March","April","May","June","July","August","September","October","November","December"),""))

    It's working fine if the year is 2014 but not if the year is different.

    Conditions:

    If the date is today then only the month should display else blank.
    The year should be ignore.
    For example:

    08/01/2000: January
    01/01/2000: blank cell
    08/01/2014: January
    01/01/2014: blank cell
    The date is in column 'p' in dd mm yyyy format. In short if the date is current date that is for today '8' then only the month should be display in the output.

    Please suggest me a correction to get correct output.

    Thank you.

    Regards,

    Mukesh
    Last edited by mukeshbaviskar; 01-09-2014 at 10:21 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] IF formula correction
    By mra1984 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-06-2013, 12:36 PM
  2. correction of formula please............
    By JE McGimpsey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  3. correction of formula please............
    By azmi in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 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