Wrestling Talk Forums supported
USA Wrestling Kansas KWCA
Wrestling Talk Forums supported & maintained by USA Wrestling-Kansas
USAW USA Wrestling Kansas
Previous Thread
Next Thread
Print Thread
#10351 11/22/01 02:13 AM
Joined: Jul 2001
Posts: 1,153
Member
Member
Joined: Jul 2001
Posts: 1,153
Are you using a spreadsheet to keep your club's roster, and wish you had a formula that would easily calculate each wrestler's current age group (using the Kids Division's August 31 cutoff)? The following is a formula I've used for years in Microsoft Excel; it calculates the age group for the current year, based on a date of birth entered in a separate cell (in the example, the date of birth would be entered in cell "F16"). If anyone has a better method of doing this, please post your solution.
Here's the formula:

=IF(ISBLANK(F16),"",MAX(IF(MOD(IF(MONTH(F16)>8,0,1)+(YEAR(NOW())-IF(MONTH(NOW())<9,2,1)-YEAR(F16)),2)>0.5,1,0)+IF(MONTH(F16)>8,0,1)+(YEAR(NOW())-IF(MONTH(NOW())<9,2, 1)-YEAR(F16)),6))

Yeah, I know it's kind of long, but all you have to do is type it in once, then copy it to all the other wrestlers.

#10352 12/11/01 09:51 PM
Joined: Dec 2001
Posts: 37
N
Member
Member
N Offline
Joined: Dec 2001
Posts: 37
just a tip...you don't have to type it in at all. Just highlight the formula and right click, hit copy, then go to your spreadsheet and paste. Easy as that, thank you for the formula!


brandee

Link Copied to Clipboard
Who's Online Now
0 members (), 9 guests, and 0 robots.
Key: Admin, Global Mod, Mod
Newest Members
Super Admin, bvswwrestling, CoachFitzOS, Dluce, Shawn Russell
12,303 Registered Users
Forum Statistics
Forums11
Topics36,091
Posts250,722
Members12,303
Most Online1,305
Mar 13th, 2025
Top Posters
usawks1 8,595
smokeycabin 6,248
Aaron Sweazy 5,262
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Release build 20240826)
Responsive Width:

PHP: 8.3.23 Page Time: 0.218s Queries: 16 (0.007s) Memory: 3.0027 MB (Peak: 3.5911 MB) Data Comp: Off Server Time: 2025-08-01 23:01:27 UTC
Valid HTML 5 and Valid CSS