Results 1 to 4 of 4

Thread: Format Date with Condition

  1. #1

    Smile Format Date with Condition



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am having trouble with a formula in excel 2007. For example, cell A1 = 8/11/2013, I want result = "Nov". I will use this formula =TEXT(A1,"MMM"). How should I put a condition if I would like to check only from Oct - Dec. Eg. 10/5/2013. ("May"), Anything not from the condition, I will want to have this result "5/10/2013". Pls help. Thank you so much!

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Not sure that why you need that, but, try:

    =IF(MONTH(A1)>=10,TEXT(A1,"MMM"),A1) or if you want the result to always be text: =TEXT(A1,IF(MONTH(A1)>=10,"MMM","M/D/YYYY"))


  3. #3
    thanxxxxxxxxxxxxxxx a lot

  4. #4
    helllllllllllllllllp me

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •