LogFAQs > #926139762

Yeah, I use the average age (once calculated) to then calculate the average date of birth. It works by taking the average age and multiplying that by 365 (days in a year). I don't factor in Leap Year when doing these calculations, but it can certainly be adjusted for. If you wanted to adjust for Leap Year, you'd multiply the average age by 365.25 instead (0.25 because of the extra day every 4 years).

Going off the old method of calculating average age, our latest age poll had an average age of 32.04. Multiplying this by 365 gives you 11694.60, which can be rounded up (or down if the decimal part is less than 0.5). Finally, you take the date of our latest age poll (8/15/2019) and subtract 11695 days from that date. This operation can be performed easily in Microsoft Excel, but it also works in Google Docs as well. The final result of subtracting 11695 days from 8/15/2019 is 8/8/1987.

I might decide to adopt the new method of calculating average age, so this current average date of birth is subject to change later on.
---

Luster Soldier --- ~Shield Bearer~ | ~Data Analyst~
Popular at school, but not as cool as Advokaiser, Guru Champ!