| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to categorize to do list by date, please | Excel Discussion (Misc queries) | |||
| Categorize certain times of day as other days | Excel Discussion (Misc queries) | |||
| Categorize Income and Expenses? | Excel Discussion (Misc queries) | |||
| Want to Automatically Re-Categorize a Downloaded Internet Spreadsheet | Excel Discussion (Misc queries) | |||
| Categorize drop down list | Excel Worksheet Functions | |||
Linear Mode
