Insert Missing Dates By Comparing Two Lists Of Dates

**Trebor76** · 10-16-2013, 03:26 AM

@ Admin,

Yes I know ISERROR was released with 2007 (I didn't post that solution BTW).

Like the solution posted by aju.thomas, your solution again only works till 8-Jan and has an extra space between "a" and "l" in "General" (must be a formatting issue with the web page).

Robert

**mahmoud-lee** · 10-16-2013, 02:41 PM

Yes, it is working only until January 8, but do not come with the rest of the values

**Trebor76** · 10-16-2013, 03:50 PM

Perhaps if you post a file with one (or both) of the macros attached we can see why it's not working and advise accordingly.

**mahmoud-lee** · 10-16-2013, 04:12 PM

This is the file that you want to work examples
With a formula Mister Admin

**Trebor76** · 10-16-2013, 04:48 PM

The file didn't have either macro attached

Anyway, run the ExcelFox macro from the Macro dialog (opened via pressing and holding the Alt button followed by pressing the F8 key) on the data in Sheet2 to get the desired results.

HTH

Robert