Count Daily Minimum/Maximum Values

the macro will track daily min/max values, and keep a count of the times these values occurred in a separate sheet in the workbook.
At first I thought simply setting up a macro to look at a predefined range of rows to find the min/max values, but some days may be missing data; therefore, I need a macro with the logic that looks for the min/max value appropriate to each specific day (which is the tricky part). Below is the detailed explanation of the process.

1)The "Main" sheet, Column A, contains days 01/05/1999 � 01/29/1999 (days are already in numerical value format). Begin in A1 and this will be the first daily value. Find the Max Value in Column D corresponding to the numerical daily value of A1.
2)Once Max Value found in Column D, Column B of same row will have the time the Max Value occurred.
3)Count time Max Value occurred in �Time Count� sheet Column C of corresponding time.
4)Move down to next daily value. Continue this process to last row in sheet.

For example, �Main� Sheet, day 01/05/1999 (numerical daily value 36165), Max Value is 1.1835 found in Cell D12. B12 has the time at 2:45. A �1� is then placed next to 2:45 or C14 of the �TimeCount� sheet. If the next day�s Max Value occurred at the same time, then a 2 would be placed in C14...........................