Count the number of times a date occurred in a report
I need to Count the amount of times a date comes up in an excel report.
The data in my report shows as follows:
7/7/2014 13:56
7/7/2014 11:26
7/7/2014 10:48
7/7/2014 9:57
7/4/2014 11:49
I need to create a formula to do this automatically, I just want to pass the report in the DATA sheet and have the formula discriminate the amount of times each date comes up.
I haven't been able to figure it out.
Thank you in advance
microsoft-excel-2010
edited Jan 28 at 22:59
fixer1234
19k144982
asked Jul 15 '14 at 18:31
Gaston AbeleiraGaston Abeleira
61
add a comment |
I need to Count the amount of times a date comes up in an excel report.
The data in my report shows as follows:
7/7/2014 13:56
7/7/2014 11:26
7/7/2014 10:48
7/7/2014 9:57
7/4/2014 11:49
I need to create a formula to do this automatically, I just want to pass the report in the DATA sheet and have the formula discriminate the amount of times each date comes up.
I haven't been able to figure it out.
Thank you in advance
microsoft-excel-2010
edited Jan 28 at 22:59
fixer1234
19k144982
asked Jul 15 '14 at 18:31
Gaston AbeleiraGaston Abeleira
61
Would you like the use of Pivot tables? They are the easiest way to generate reports. Line in your case - finding out "how many times the data is repeated" for example...
– Prasanna
Jul 15 '14 at 18:33
I download a report from one of our tools that shows all the evaluations done in a month, the line that shows the date has the following format : 7/7/2014 13:56. I need to count how many evaluations were done in each day.
– Gaston Abeleira
Jul 15 '14 at 18:40
add a comment |
I need to Count the amount of times a date comes up in an excel report.
The data in my report shows as follows:
7/7/2014 13:56
7/7/2014 11:26
7/7/2014 10:48
7/7/2014 9:57
7/4/2014 11:49
I need to create a formula to do this automatically, I just want to pass the report in the DATA sheet and have the formula discriminate the amount of times each date comes up.
I haven't been able to figure it out.
Thank you in advance
microsoft-excel-2010
edited Jan 28 at 22:59
fixer1234
19k144982
asked Jul 15 '14 at 18:31
Gaston AbeleiraGaston Abeleira
61
I need to Count the amount of times a date comes up in an excel report.
The data in my report shows as follows:
7/7/2014 13:56
7/7/2014 11:26
7/7/2014 10:48
7/7/2014 9:57
7/4/2014 11:49
I need to create a formula to do this automatically, I just want to pass the report in the DATA sheet and have the formula discriminate the amount of times each date comes up.
I haven't been able to figure it out.
Thank you in advance
microsoft-excel-2010
microsoft-excel-2010
edited Jan 28 at 22:59
fixer1234
19k144982
asked Jul 15 '14 at 18:31
Gaston AbeleiraGaston Abeleira
61
edited Jan 28 at 22:59
fixer1234
19k144982
asked Jul 15 '14 at 18:31
Gaston AbeleiraGaston Abeleira
61
edited Jan 28 at 22:59
fixer1234
19k144982
edited Jan 28 at 22:59
fixer1234
19k144982
edited Jan 28 at 22:59
fixer1234
19k144982
19k144982
asked Jul 15 '14 at 18:31
Gaston AbeleiraGaston Abeleira
61
asked Jul 15 '14 at 18:31
Gaston AbeleiraGaston Abeleira
61
asked Jul 15 '14 at 18:31
Gaston AbeleiraGaston Abeleira
61
61
Would you like the use of Pivot tables? They are the easiest way to generate reports. Line in your case - finding out "how many times the data is repeated" for example...
– Prasanna
Jul 15 '14 at 18:33
I download a report from one of our tools that shows all the evaluations done in a month, the line that shows the date has the following format : 7/7/2014 13:56. I need to count how many evaluations were done in each day.
– Gaston Abeleira
Jul 15 '14 at 18:40
add a comment |
Would you like the use of Pivot tables? They are the easiest way to generate reports. Line in your case - finding out "how many times the data is repeated" for example...
– Prasanna
Jul 15 '14 at 18:33
I download a report from one of our tools that shows all the evaluations done in a month, the line that shows the date has the following format : 7/7/2014 13:56. I need to count how many evaluations were done in each day.
– Gaston Abeleira
Jul 15 '14 at 18:40
Would you like the use of Pivot tables? They are the easiest way to generate reports. Line in your case - finding out "how many times the data is repeated" for example...
– Prasanna
Jul 15 '14 at 18:33
Would you like the use of Pivot tables? They are the easiest way to generate reports. Line in your case - finding out "how many times the data is repeated" for example...
– Prasanna
Jul 15 '14 at 18:33
I download a report from one of our tools that shows all the evaluations done in a month, the line that shows the date has the following format : 7/7/2014 13:56. I need to count how many evaluations were done in each day.
– Gaston Abeleira
Jul 15 '14 at 18:40
I download a report from one of our tools that shows all the evaluations done in a month, the line that shows the date has the following format : 7/7/2014 13:56. I need to count how many evaluations were done in each day.
– Gaston Abeleira
Jul 15 '14 at 18:40
add a comment |
1 Answer
1
active
oldest
votes
I have done a sample worksheet and uploaded to this location. See if this is what you need.
Here is how it works:
1. From your tool output which is a combination of date and time, we will extract the date and time in two separate columns. The pre-requisite for doing this to define the column (which is the tool output) as "text" type. Right click-> Format cells-> select "Text" as type.
2. The extraction of date and time is done by "left" command and "mid" command respectively.
3. After the date and type are available in two different columns, just use pivot table and generate the report you want. (in your case the number of times a particular day has occurred)
I hope this helps!
date.xlsx - Sample file
answered Jul 15 '14 at 19:05
PrasannaPrasanna
3,15732240
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f783536%2fcount-the-number-of-times-a-date-occurred-in-a-report%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I have done a sample worksheet and uploaded to this location. See if this is what you need.
Here is how it works:
1. From your tool output which is a combination of date and time, we will extract the date and time in two separate columns. The pre-requisite for doing this to define the column (which is the tool output) as "text" type. Right click-> Format cells-> select "Text" as type.
2. The extraction of date and time is done by "left" command and "mid" command respectively.
3. After the date and type are available in two different columns, just use pivot table and generate the report you want. (in your case the number of times a particular day has occurred)
I hope this helps!
date.xlsx - Sample file
answered Jul 15 '14 at 19:05
PrasannaPrasanna
3,15732240
add a comment |
I have done a sample worksheet and uploaded to this location. See if this is what you need.
Here is how it works:
1. From your tool output which is a combination of date and time, we will extract the date and time in two separate columns. The pre-requisite for doing this to define the column (which is the tool output) as "text" type. Right click-> Format cells-> select "Text" as type.
2. The extraction of date and time is done by "left" command and "mid" command respectively.
3. After the date and type are available in two different columns, just use pivot table and generate the report you want. (in your case the number of times a particular day has occurred)
I hope this helps!
date.xlsx - Sample file
answered Jul 15 '14 at 19:05
PrasannaPrasanna
3,15732240
add a comment |
I have done a sample worksheet and uploaded to this location. See if this is what you need.
Here is how it works:
1. From your tool output which is a combination of date and time, we will extract the date and time in two separate columns. The pre-requisite for doing this to define the column (which is the tool output) as "text" type. Right click-> Format cells-> select "Text" as type.
2. The extraction of date and time is done by "left" command and "mid" command respectively.
3. After the date and type are available in two different columns, just use pivot table and generate the report you want. (in your case the number of times a particular day has occurred)
I hope this helps!
date.xlsx - Sample file
answered Jul 15 '14 at 19:05
PrasannaPrasanna
3,15732240
I have done a sample worksheet and uploaded to this location. See if this is what you need.
Here is how it works:
1. From your tool output which is a combination of date and time, we will extract the date and time in two separate columns. The pre-requisite for doing this to define the column (which is the tool output) as "text" type. Right click-> Format cells-> select "Text" as type.
2. The extraction of date and time is done by "left" command and "mid" command respectively.
3. After the date and type are available in two different columns, just use pivot table and generate the report you want. (in your case the number of times a particular day has occurred)
I hope this helps!
date.xlsx - Sample file
answered Jul 15 '14 at 19:05
PrasannaPrasanna
3,15732240
answered Jul 15 '14 at 19:05
PrasannaPrasanna
3,15732240
answered Jul 15 '14 at 19:05
PrasannaPrasanna
3,15732240
answered Jul 15 '14 at 19:05
PrasannaPrasanna
3,15732240
3,15732240
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f783536%2fcount-the-number-of-times-a-date-occurred-in-a-report%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Would you like the use of Pivot tables? They are the easiest way to generate reports. Line in your case - finding out "how many times the data is repeated" for example...
– Prasanna
Jul 15 '14 at 18:33
I download a report from one of our tools that shows all the evaluations done in a month, the line that shows the date has the following format : 7/7/2014 13:56. I need to count how many evaluations were done in each day.
– Gaston Abeleira
Jul 15 '14 at 18:40