how to categorize dates
 

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!

how to categorize dates
 

Hi,

This will calculate the quarter for a date in A2

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

Mike

"Neri" wrote:

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!

how to categorize dates
 

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!



"Mike H" wrote:

Hi,

This will calculate the quarter for a date in A2

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

Mike

"Neri" wrote:

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!

how to categorize dates
 

You would have to describe you data layout

"Neri" wrote:

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!



"Mike H" wrote:

Hi,

This will calculate the quarter for a date in A2

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

Mike

"Neri" wrote:

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!