how to categorize dates

  • Thread starter Thread starter Neri
  • Start date Start date
N

Neri

I just wanted to categorize the dates quarterly. Like for example, if the
date is from January to March, it will be included in Quarter1 category. I
wanted to know how many projects have been made in Quarter1 from a specific
person.

Please help me! thanks!
 
Hi,

This will calculate the quarter for a date in A2

=INT((MONTH(A2)-1)/3)+1

Mike
 
Ok,I got it. but how about, if i wanted to know the number of projects of Mr.
X in quarter1? can you please help me with that? thanks!
 
You would have to describe you data layout

Neri said:
Ok,I got it. but how about, if i wanted to know the number of projects of Mr.
X in quarter1? can you please help me with that? thanks!
Click to expand...
 
You must log in or register to reply here.

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

Similar Threads

Creating nested IFs with variables? 3
How do I Turning Dates into Quarters 4
Categorize Continuous Variable into a Discrete One based on a table 1
guideline needed to structure table 1
Help with report sums 2
Categorize emails on receipt to match categories from contacts 1
Need help changing a database 5
Categorizing Contacts 2

Back
Top