Count Of Names By Date Of Birth (DOB)
Jun 26, 2008
I am using Office 2007 - Excel
I have a list of students with associated Schools
For each High School -Based on students Date of Birth (DOB) I am trying to get a count for:
Students UNDER 16 DOB before 8/25/91 and for each high school students over 16 DOB after 8/25/91
I thought subtototals, countif , maybe a pivot table to break down by school then do the 2 counts -
but I am at a loss for a formula to do the count
I have attached a sample file but the actual file has thousands of students and 23 different High schools which is why I was trying for subtotals or Pivot
View 8 Replies
ADVERTISEMENT
Feb 21, 2009
Is it possible to convert a students DoB into their term of birth (ToB).
I.e. a student has the DoB of 1/1/2001 which would mean their ToB would be 'Spring'
I suppose what I'm after is...
If a DoB falls into one of three groups
1/1/year to 30/4/year = 'Spring'
1/5/year to 31/8/year = 'Summer'
1/9/year to 31/12/year = 'Autumn'
The year of birth is irrelevant, it's the month which determines the 'term of birth' (Spring/Summer/Autumn).
View 3 Replies
View Related
Feb 5, 2009
I have several old spreadsheets that contain patient information. Except for names, dates of birth, and dates of surgery there is nothing consistent about them. Not only that, the old spreadsheets were in various stages of compiliation and recompilation when they were abandoned. So now there are multiple duplications of old names added to lists of new names spread across multiple spreadsheets. I have to identify names that are not already in my database and add them.
I have a formula that I found on the internet that I can use to check if a patient’s last name in an old spreadsheet is one that already appears in my main database. In my attached example the formula looks like this:
View 3 Replies
View Related
Mar 16, 2014
I am Using Excel 2013 on windows 8 OS,
I have no programming background but I have an Idea about it and I try to write some VBA Macros.
I have 27 Excel files which contain each of them 257368 Row Concerning personal information about persons
the File Format is as Follows:
Place of Birth (POB); Name; Father's Name; Family Name; ID Number; Ethnicity,>>
View 2 Replies
View Related
Jul 25, 2009
I have got a database wherein it contains the details like Employee Name, Birth Date, Date of Joining, etc in Sheet1. Suppose, Employee AAA birth date is 30/Jul/1980. When on 30th July 2009, it should display the Employee Id in Cell C3.
How should I lookup for the current date & month from the Employee Birth Date?
View 3 Replies
View Related
Sep 16, 2009
how to calculate the age from the date of birth and was given these two responses
1) I may be way off here but all that coding seems a waste !
I have in cell A1 = BLANK <--- enter your DOB here
I have in cell A2 =NOW()
in cell A3 do = A2-A1
Format that to General
In Cell A4 do =A3/365
Format that to no deciamal places and you get the age - this one is adding a year to everyones age?
2) Alternatively, if the DOB is A1 :-
=INT(YEARFRAC(A1,TODAY(),1)) - This one does not work it is saying there is an error with the "yearfrac"?
It is also when I am trying to put these into a pivot table, the pivot table is listing these down to 5 decimal places( when I have formatted to zero)????
View 2 Replies
View Related
Sep 6, 2005
http://www.cpearson.com/excel/datedif.htm
--
"malvis" wrote:
> Is there a formula that can calculate age when given only Date of Birth?
View 14 Replies
View Related
Jun 13, 2013
I am building a spreadsheet that has everyone's birth date on it. If the person is not 22 years of age or older I would like for the cell text containing their birth date to be highlighted in RED.
View 9 Replies
View Related
Aug 25, 2008
I have the date of death and the age at death in Years, Month, Days. What formula would I use to figure the date of birth?
View 9 Replies
View Related
Dec 8, 2008
I'm trying to use a list of date of births to determine an age output.
However the date of births are all in a simple reverse formate, eg
19790822 would be 22nd August 1979
Ideally, i would take this number and the output would just be the persons age in whole years.
View 3 Replies
View Related
Dec 10, 2009
I need a formula to calculate age today based on a person's date of birth. I used to know this but I have not used it for awhile.
View 4 Replies
View Related
Jan 21, 2004
I am looking for a formula that calculates an individuals exact age given their date of birth. That shows just the age in years.
View 9 Replies
View Related
Apr 21, 2008
I am using the following formula:
=DATEDIF(F7,TODAY(),"Y")
I have a about 1200 rows with a column of student's birth dates. I need to convert the dates to ages and have them inputted in the next column Ages. I ran the code in the 'Age' column and it worked for the first birth date. But I do not know how to copy the code to the rest of the rows so it will convert every birth date in each row.
View 5 Replies
View Related
Oct 1, 2008
I need to find out over aged students by date of birth - now()-age started to school: DOB 8/16/2000 , Now() Age started school is 8/30/2005. Student is in grade 1. should be age 6, however, he is 8. Answer should be a little over 2 yrs.
View 2 Replies
View Related
May 4, 2008
how to make a cell to change color oatomatically accordant to Year and Month reflexted already in the cell. I have a spreadsheet with Names,Surnames,DOB and also a column that is given the AGE years months and days.
If somebody reaches 21 -1 -2 -3 months this should show different colors in the persons row in a particular column. The function used for the AGE is fund on ozgrid.com: =DATEDIF(H4,TODAY(),"y")&" years "&DATEDIF(H4,TODAY(),"ym")&" months "&DATEDIF(H4,TODAY(),"md")&" days"
View 4 Replies
View Related
Oct 7, 2007
I have a list of birthdays (in date-month-year format) and simply want to highlight them if the date and month are past today's date.
View 9 Replies
View Related
May 24, 2007
I have database of my entire staff with thr date of birth and joining date, in the format "mm/dd/yyyyy".
I want if the date of birth is equal to today()+1, that means if someone is having his b'day on 25may ,and today is 24 may so its cell colour should turn into red.
I know conditional formatting is to be used here. but bit confused with the formula.
I am trying with this
=IF(TEXT(C3,"dd-mmmm")=TODAY()+1,true,FALSE), but not working.
means I want if someones b'day is coming , I want to ge t informed earlier.
View 9 Replies
View Related
Apr 13, 2006
I've got one column with names in it and a second column with dates in it. What I'm trying to do is generate a count in a third column next to each name with the number of times the name appears in the name column when there is a date in the corresponding date column. If the date column is blank I want the count column to remain blank.
For example:
Assigned To: Number Completed Date
Joe 2 1/1/06
Jane
Joe 2 2/22/06
I know that there will be repeated info but the end user doesn't care.
View 11 Replies
View Related
Oct 28, 2008
Every day I pull a report showing a list of agents that committed an infraction. I want to be able to count how many times each agent committed an infraction. How do I do that? I tried Frequency and it did not work, or am I missing something?
View 5 Replies
View Related
May 9, 2008
I have a small sample sheet attached..I need a formula in column c which identifies how often the name in column B hass occurred already in the sheet. Auto Merged Post Until 24 Hrs Passes;File attached
View 3 Replies
View Related
Jul 9, 2009
The question is presented and explained within the attached WB.
View 4 Replies
View Related
Nov 17, 2011
What is the formula for sumproduct to count a say column c for a range of names and as long it match column k for yes.
View 1 Replies
View Related
May 21, 2008
I've been trying to solve this problem all afternoon and evening but cannot think how to do it. I'm a basic (very) VBA user and the best I could come up with is below.
I have a sheet called Data. In column A I have names, and in column B I have dates (day, month and year).
What I am trying to do is to filter the unique names that occur during the selected month and year (day is irrelevant) and then count the number of times that name appears in the selected time period.
This is what I have so far, but it's not working at all!
Sub countNamesMonth()
Dim rangeEnd As Long
Dim i, y, x
Dim cell As Range
rangeEnd = Cells(Sheets("Data").Rows.Count, "A").End(xlUp).Row
y = 2
x = 2
View 5 Replies
View Related
Jan 6, 2014
I have a list of names all in one column, separated by row...
Example...
John Doe
John Doe
Jane Doe
Jane Doe
Jane Doe
James Jones
James Jones
I want to count how many times each name appears. Like this:
John Doe | 2
Jane Doe | 3
James Jones | 2
This is a very large list of names and I prefer not to have to type each single name into a formula because there are hundreds of separate names.
View 4 Replies
View Related
May 25, 2012
I have many names of people in column A .. what formula do i use to count all the names in the range in coumn A?
View 2 Replies
View Related
Nov 17, 2007
see my attached sheet cotaining the following questions. in a day report sheet how should i count request matching the crateria of date and other conditions. in a monthly report a heavy conditional sum calculation which make slower sheets how can i make it faster.
View 2 Replies
View Related
Apr 4, 2013
I've got a set of data that I update once a month and the number of team members per team changes all the time. I'm trying to write a formula that basically says, if the date matches AND the manager name matches, count the number of team members.
In the attached sample if A2 and B4 are found in the data set, count the number of SalesReps they have. So I'm looking at Sarah for February 2013, she has two sales reps that sold something, but Katherine appears twice, so I'm not looking for a result of 3, the correct answer is 2. How do I write the formula?
A2 will look to the data range of A14:A23 and SarahK will look to I14:I23, but I want to count H14:23.
View 9 Replies
View Related
Oct 26, 2006
I am desperately in need of a macro that will count the number of items in column A of each worksheet and then summarize the results next to the names of the worksheets (i.e. in two adjacent columns) on Sheet 1 of the book. Obviously, Sheet 1 needs to be ignored by the macro.
View 3 Replies
View Related
Nov 11, 2013
I have a colmun of dates of birth, how do I sort them so that they are in order of the day and not by the year?
View 14 Replies
View Related
Dec 21, 2009
I have a list (starting with A2) with years of birth (as "1928" for born that year etc.), now - how can I (1) find out how old they are 2009? and (2) can I sort the ages out in three age groups (18-30; 31-55; 56-100)?
View 9 Replies
View Related