This does suggest adding a column or two to my firearms spreadsheet to do the actual math.
Quick count: __ , no ... better to just say that ~43% of mine fall within the Older category.How many usable guns do you have that are older than you?
Yeah, I'm thinking "Production Date"--the +avg() won't tell you much, but the +min() and +max() will be cool.and maybe add a few new ones.
Yeah, I'm thinking "Production Date"--the +avg() won't tell you much, but the +min() and +max() will be cool.
And, I'm thinking a column of +if([cell]<[year],1, 0). The +sum() of that column wuld give younger than [year], which could give an average or a percentage you your discretion.
I think I have 8 that are over 100 and probably another dozen that are older than me.
My Ruger Mk1 target is likely among them as we were both 65 models but my birthday is in Dec lol.
So you are an antique as well.At 79 years of age, I think that's kinda cool and reassuring!
LOLHmmmmmmm. You have 8 over 100 but you didn't say they are older than you. But you have a dozen that are older than you. Do we have a centarian among us?
LOL
well since I stated in my post that I was born in December of 65 you wouldn't thunk the math is that hard.
I'm 57 so yes the ones that are over 100 are older than me also another dozen that are over 57.
So 8+12=20 total guns older than me for those youngsters that have been subjected to new math.
In poking around on mine, the best format--for me at least--looks to be 4 digit year number, for not needing to be interpreted out of Julian date or from text strings.most of this column remains blank so far.