Results 1 to 6 of 6

Thread: inserting date

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 08-05-2014, 02:04 AM #5
    rollis13
    rollis13 is offline
    Member rollis13's Avatar
    Join Date
    Nov 2012
    Posts
    36
    Rep Power
    0
    Have a try (no VBA):
    Copy this formula in Sheet l cell C1

    =MID(B1,SEARCH("????/??/??",B1),10)

    Copy this other formula in Sheet l cell C2 and then copy down

    =IF(ISERROR(MID(B2,SEARCH("????/??/??",B2),10)),C1,MID(B2,SEARCH("????/??/??",B2),10))
    Last edited by rollis13; 08-05-2014 at 02:07 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Inserting Image In VBA User Form Caption
    By littleiitin in forum Download Center
    Replies: 3
    Last Post: 02-22-2021, 03:07 PM
  2. Inserting time in spreadsheet
    By papabill in forum Excel Help
    Replies: 17
    Last Post: 10-25-2013, 01:34 PM
  3. Compare Date Columns In Excel And Pull The Latest Date
    By marentette010 in forum Excel Help
    Replies: 1
    Last Post: 07-31-2013, 11:56 PM
  4. Lookup Start Date And End Date Range For Specific Date Using Formula
    By mahmoud-lee in forum Excel Help
    Replies: 5
    Last Post: 06-15-2013, 12:40 PM
  5. Replace Incorrect Date In Cell To Another Valid Date
    By DARSHANKmandya in forum Excel and VBA Tips and Tricks
    Replies: 2
    Last Post: 03-21-2013, 09:27 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