Results 1 to 10 of 25

Thread: Insert Missing Dates By Comparing Two Lists Of Dates

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 10-15-2013, 03:08 PM #1
    Trebor76
    Trebor76 is offline
    Junior Member
    Join Date
    Aug 2013
    Posts
    18
    Rep Power
    0
    Please check the below formula will help you
    It works until 8-Jan then stops. BTW there is an extra space between "a" and "l" for some reason that causes the formula to return #VALUE! errors.

    I don't think you can do this via a formula. I could be wrong, but it needs a macro in my humble opinion.

    Robert
    Reply With Quote Reply With Quote
  2. 10-15-2013, 03:22 PM #2
    mahmoud-lee
    mahmoud-lee is offline
    Senior Member
    Join Date
    Mar 2013
    Posts
    146
    Rep Power
    0
    Thank you for your tired
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. List of Dates In DropDown Starting From Today()
    By rich_cirillo in forum Excel Help
    Replies: 5
    Last Post: 04-10-2013, 05:58 PM
  2. Find Missing Values By Comparing Two Columns / Find Missing Data In Column
    By Howardc in forum Excel Help
    Replies: 4
    Last Post: 04-05-2013, 12:08 PM
  3. How to Extracting dates and days between 2 dates.
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 9
    Last Post: 08-11-2012, 09:11 PM
  4. The Number of Years, Months and Days Between Two Dates
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 7
    Last Post: 06-08-2012, 10:35 PM
  5. Visual Plotter basis given dates and activity
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 2
    Last Post: 03-07-2012, 02:37 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