+ Reply to Thread
Results 1 to 2 of 2

Date & text

  1. #1
    Registered User
    Join Date
    11-20-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    22

    Date & text

    Dear All,
    Hope you are doing great!.
    I need a help.
    I have to calculate difference between dates but at some instances text is unavoidable.
    For Eg.

    1-Mar-2022 - 28-Feb-2022 = 1
    1-Mar-2022 - "Available" = 44621

    I need a solution to stop/hide showing the above result 44621.
    Please help.

    regards
    Krishnamoorthy S

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,647

    Re: Date & text

    It impossible to tell how many cells your values are in. Read the yellow banner (top) and post a sample Excel sheet.
    Glenn



+ 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: 7
    Last Post: 07-11-2019, 11:27 AM
  2. [SOLVED] Prefill text box in userform with today's date but allow user to enter unique date
    By moosetales in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-02-2014, 09:17 AM
  3. How to update Text Box2 with date 14 days after selected date in Text box1...
    By mjc61 in forum Access Programming / VBA / Macros
    Replies: 6
    Last Post: 01-26-2014, 09:17 PM
  4. [SOLVED] How to convert exported text date to desired date format with excel vba.
    By sktneer in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 10-03-2013, 01:08 AM
  5. Replies: 1
    Last Post: 02-14-2013, 10:40 PM
  6. Need to capture date data in a text string containing a date and time stamp
    By Grilleman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-07-2013, 01:14 PM
  7. [SOLVED] Keep Date in Date Text Format not Date Value
    By wonderfulle in forum Excel General
    Replies: 2
    Last Post: 08-10-2010, 07:44 PM

Tags for this Thread

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