I have a giant spreadsheet which contains a date on every row. The date is always in Column A, and repeats several times until the next date, which also repeats several times. Basically, there may be as many as 100 items entered per day, each dated as such.
The sheet covers the year to date. In order to perform some calculations, I need to be able to count the number of individual days covered. These dates never contain a weekend day, so a simple (first date - second date) formula won't work.
Does anyone have any idea how I might go about counting the number of individual days covered by this spreadsheet? I'm simply looking for the number of individual date criteria which exist in the sheet.
Thanks for all your help!