IIs the table set up right?
I usually dont store dates as field 1, 2, 3 etc.. rather have a project table then assign dates through a relationship of 1 to many.
As you are in effect counting across a row rather than down a column.
Or maybe you can do a count in a field at after Date4...