Hi,
Usually the simplest way to do this is have the count you require on each daily sheet in the SAME cell on each sheet. Then you can use a formula like the following. It's also common to insert two blank sheets, one as the first tab and the other the last tab with all the days in between.
where 'First' & 'Last' are the two blank sheets and G2 the cell containing your formula.
It's not clear whether that formula you show is on each sheet or on a master summary sheet. However upload a daily sheet so that we can advise further.
That said, keeping your daily data on 365 sheets is really not the best approach. You ae complicating any analysis you want by doing so. All data should be on a single sheet and with an extra initial column that contains the date of each record. A simple macro could be written to create that single sheet database and I would urge you to seriously consider that.
Bookmarks