+ Reply to Thread
Results 1 to 6 of 6

IF & EDATE Formula together for an End Date but how to ignore text in start date cell

  1. #1
    Registered User
    Join Date
    09-19-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    13

    IF & EDATE Formula together for an End Date but how to ignore text in start date cell

    I have =IF(K4="","",(EDATE(K4,6))) to keep my cells blank untill I enter the start date, I now recently needed to add text along with the start date and cant have a seperate start date column because the file already has so much data were trying to make it smaller. Is there anyway to change the above formula to only recognize the date in the column? or maybe a different formula all together?

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: IF & EDATE Formula together for an End Date but how to ignore text in start date cell

    try

    =IF(ISNUMBER(K4),EDATE(K4,6),"")

  3. #3
    Registered User
    Join Date
    09-19-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    13

    Re: IF & EDATE Formula together for an End Date but how to ignore text in start date cell

    "In Training 9/24/2013" Is how the start date cell will look if that helps. Thanks for quick reply but still no cigar.

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: IF & EDATE Formula together for an End Date but how to ignore text in start date cell

    OK, I see now..

    Try

    =IF(K4="","",EDATE(TRIM(RIGHT(SUBSTITUTE(K4," ",REPT(" ",LEN(K4))),LEN(K4))),6))

  5. #5
    Registered User
    Join Date
    09-19-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    13

    Re: IF & EDATE Formula together for an End Date but how to ignore text in start date cell

    Jonmo1 that hit it right on the nail thank you so much!

  6. #6
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: IF & EDATE Formula together for an End Date but how to ignore text in start date cell

    You're welcome.

+ 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. [SOLVED] Add date to next available cell, ignore existing date entries
    By MelHerndon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2013, 12:01 PM
  2. Replies: 1
    Last Post: 10-02-2012, 02:42 PM
  3. Return cell value on calendar for all dates between start date & end date
    By mmctague in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-23-2012, 02:11 PM
  4. Replies: 1
    Last Post: 03-16-2011, 11:05 PM
  5. Replies: 7
    Last Post: 11-16-2008, 05:48 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1