+ Reply to Thread
Results 1 to 6 of 6

FIND Date Month Year with conditions

  1. #1
    Forum Contributor
    Join Date
    12-21-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    387

    FIND Date Month Year with conditions

    Hi,
    I have a specific text in cell "A1" as "ABCDEWXYZ19N0411500AB
    in above text
    (Letter thirteen,fourteen indicate date = 04)
    (Letter twelve indicate month = Nov)
    (Letter ten,eleven indicate year = 19)

    I want to find : if first letter must be "A" and twelve letter must be "N" then
    in cell "B1" reply date as "04-Nov-19" otherwise BLANK

    Thanks
    My English is very poor, so please be patient >_<"

    Thanks & Regards.
    hkbhansali

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,097

    Re: FIND Date Month Year with conditions

    How about
    =IF(AND(LEFT(A1,1)="A",MID(A1,12,1)="N"),DATE(2019,11,MID(A1,13,2)),"")
    And format B1 to suit.

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: FIND Date Month Year with conditions

    since I did some work on it I will post my interpretation... =IF(AND(LEFT(B1,1)="A",MID(B1,12,1)="N"),MID(B1,13,2)&"-"&"Nov-"&MID(B1,10,2),"")

    I'm assuming you have something very specific in mind since you couldn't use a similar formula for January or June or July as all would be J (same with March and May etc.).
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,097

    Re: FIND Date Month Year with conditions

    Quote Originally Posted by Sambo kid View Post
    I'm assuming you have something very specific in mind since you couldn't use a similar formula for January or June or July as all would be J (same with March and May etc.).
    Not to mention April & August

  5. #5
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: FIND Date Month Year with conditions

    Not to mention April & August
    That is why I put in etc. LOL.

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,097

    Re: FIND Date Month Year with conditions

    Oops, didn't see that bit

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 06-26-2019, 11:46 AM
  2. Replies: 1
    Last Post: 01-01-2016, 04:33 PM
  3. Sort month/date/year data using month and date only
    By SMW820 in forum Excel General
    Replies: 8
    Last Post: 11-18-2014, 08:39 AM
  4. Need to convert Month/Date/Year to Year/Month/Date so excel will recognize
    By juliettelam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2014, 04:17 PM
  5. find time left in month.days unit between two dates(in YEAR.MONTH.DAY)
    By xcfeng95 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 02-21-2014, 12:55 PM
  6. Replies: 3
    Last Post: 09-04-2013, 10:49 AM
  7. Replies: 1
    Last Post: 08-13-2012, 11:18 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