Using =HLOOKUP(999999999999,F2:AC2,1,1) I am obtaining a last date entered in
E2.
Must type date in DD/MM/YYYY format.

To add how many time a date (by month appears) Im using
=COUNTIF(F2:F174,"*.7.2006")

It appears to me a conflict of date formats - just not sure how to change so
both formulars read. Any Assistance?