+ Reply to Thread
Results 1 to 2 of 2

if formual for dates with text in it

  1. 03-17-2016, 06:30 PM #1
    bell_man
    bell_man is offline
    Registered User
    Join Date
    07-03-2014
    Location
    jackson,ga
    MS-Off Ver
    2010
    Posts
    13

    if formual for dates with text in it

    Need a (if) formula to disregard the text in A2. in the attached you can see the formula I have gives me the incorrect solution.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-17-2016, 06:34 PM #2
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,787

    Re: if formual for dates with text in it

    Will you always have a single letter after the date in column A?

    Pete
    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. Array changes dates stored as dates into text.
    By KNevland in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-02-2014, 08:56 AM
  2. [SOLVED] Formual require for formatting the text columns.
    By kasi.maddula in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-31-2013, 11:38 PM
  3. Formual require for formatting the text columns.
    By kasi.maddula in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-31-2013, 06:08 AM
  4. Conditional Formatting, Cells containing dates. How do I have dates and text?
    By corabell in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-29-2013, 11:23 AM
  5. Formual or VBA for replacing text in a formula
    By jvbeats in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-13-2012, 04:43 PM
  6. [SOLVED] Formual vs Value
    By mpeplow in forum Excel General
    Replies: 1
    Last Post: 11-07-2006, 07:06 PM
  7. [SOLVED] Format text 'dates' to real dates
    By Jacy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-23-2006, 09:15 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