Track attendance points for a rolling year

Here is a different way of doing things (not fully developed but enough to give you an idea) involving a table and Pivot Table to give summary reports.

The reason for keeping records in this format is that there is a complete record of the leave taken and reports can easily be developed from it both from an individual perspective and a corporate wide perspective. The records are in TABLE format so records can be extracted using the filtering feature on each column. There is also the ADVANCED FILTER which is well worth the trouble learning.

As a simple example, I have added a small area that will compute the points for an individual between the dates specified.

As long as you keep the main data, you can create reports covering any date period and for any type of leave taken. With your original format, this isn't very easily done especially if reporting periods cover more than what is in a calendar year.

A relational database is a much better tool for this kind of record keeping.

Welcome to Excelforum.

I see that you have a question regarding a solution to a problem posted previously by another member. You should post your own thread and if necessary paste a link back to this thread. This will ensure that you actually get traffic to your question. A lot of people don't keep subscriptions to solved threads and would therefore not see your question.

I will this time answer your questions if I can. If you have further questions, start a new thread of your own so that the general membership have a chance to help you.
1. There are two tables on Sheet1. The top table is just a normal Excel table where data is entered. The other table which is a little further down the worksheet and more toward the center is a Pivot Table. If you click in this table, a pane opens on the right side showing the Fields for the table, The placement of the fields in different areas at the bottom of the pane. This placement determines how the table is presented.

2. If the dates in the Pivot Table were grouped by not only by year but by year, and month with possibly day, a different set of statistics could be drawn by filtering to get the time period required. This would in my opinion render the summary worksheet redundant.

I recommend that you take this workbook and "play around with it" to see where it meets requirements and where it doesn't. Eliminate the parts that don't meet requirements and design what you think would work for you. Make a mock-up showing what you want if you have to. If you run into problems, create a new thread of your own posing questions that you need answers to and upload your workbook minus sensitive data so that a solution can be worked out.

Thank you for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Welcome to the forum.

You should create a new thread of your own stating what problem you are facing. Posting in an old thread may not give your problem the exposure required to get a satisfactory solution. Posting your problem in someone else's thread is called "hijacking" which is against the rules.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data. (Remove private or sensitive data that shouldn't be published)

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Click on Browse under Upload Files from your Computer and then find the file on your computer using the dialogue that opens. Click on Open then click on Upload. Click on Close this Window. Click on Submit.

Hi Dk & Welcome the Forum,

Please reference the below which also applies to your question.

Originally Posted by newdoverman

Welcome to the forum.

You should create a new thread of your own stating what problem you are facing. Posting in an old thread may not give your problem the exposure required to get a satisfactory solution. Posting your problem in someone else's thread is called "hijacking" which is against the rules.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data. (Remove private or sensitive data that shouldn't be published)

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Click on Browse under Upload Files from your Computer and then find the file on your computer using the dialogue that opens. Click on Open then click on Upload. Click on Close this Window. Click on Submit.

Welcome to the forum.

It appears that you have a similar problem as was posed at the start of this thread.

You should create a new thread of your own stating what problem you are facing. Posting in an old thread may not give your problem the exposure required to get a satisfactory solution. Posting your problem in someone else's thread is called "hijacking" which is against the rules.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data. (Remove private or sensitive data that shouldn't be published)

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Click on Browse under Upload Files from your Computer and then find the file on your computer using the dialogue that opens. Click on Open then click on Upload. Click on Close this Window. Click on Submit.

dkcollierjr welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Hello lgsikaffy. Welcome to the forum.

As a new member you may not be familiar with our forum rules.

One of them is Rule 4:
[/I]RULES. Do not post a question in the thread of another member -- please start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.