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!
|