This article should help.Excel Count Unique Values

You can add a cell in each sheet that counts the unique dates, then have a summary cell to add them from all the sheets.