How to automatically increment a count by date

K

kimdnw

My boss has me working a sheet of reports by his subordinates. I compile the
report, number it, then have a series of "Countif" statements that give me
the number of reports submitted by a specific subordinate.

He would now like to see a column of submitted/expected. The expectation is
one per week. Is there an easy way to have a column that increments +1 per
calendar week, so I don't need to go in and type the new number every week
for each subordinate?

Kim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top