Student's Age As of Sept 1st

Moriah Petersen Griffin

I'm looking for a way to quickly determine a student's age as of September 1st. We use this information to determine which grade level the student is eligible for and I can't seem to find a way to do that in Blackbaud so far. Any thoughts or suggestions?

Thanks!

Moriah

Brian LeBlanc

@Moriah Petersen Griffin At what point in the process do you determine eligibility? In our case, we use an inquiry as the first step in the admissions process, and have a candidates list that we run to send an official note to respond to that inquiry. I always sort that candidates list by DOB and can quickly identify students who do not meet the age cutoff, and send a different official note to those students. Happy to demonstrate if you'd like!

Kim Ashcraft

@Moriah Petersen Griffin
I was intrigued by your question, so I looked at some Excel formulas to do this. Here is a small sampling of students with their age as of 9.1.23. Once I understood how the formula was working, I was able to do this for our whole student population in about a minute. If you are willing to export the names and birthdates into Excel, then perhaps this would be a solution for you. Start date is the student's birth date.

If you want the formula, let me know and I'll send it. Kim

Moriah Petersen Griffin

@Kim Ashcraft
This is exactly what I was looking for! Do you mind sharing the formula? Thank you!

Kim Ashcraft

@Moriah Petersen Griffin
Not at all. I'm not sure whether you need the complexity of years, months, days. The formula is simpler if you don't do month and days. Also, I assume you know how to use Excel formulas, in general? This is a dateif formula that is concatenated. I'll copy it as I found it and also the formula with my cells inserted so you can see that. Let me know if you have any problems! Kim

=DATEDIF(start, end, "y") & "y " & DATEDIF(start, end, "ym") & "m " & (DATE(YEAR(end), MONTH(end) - DATEDIF(start,end,"m"), DAY(end))-start) & "d"

=DATEDIF(C22, D22, "y") & "y " & DATEDIF(C22, D22, "ym") & "m " & (DATE(YEAR(D22), MONTH(D22) - DATEDIF(C22,D22,"m"), DAY(D22))-C22) & "d"

Moriah Petersen Griffin

@Kim Ashcraft Perfect, thank you!