#while i'm good at math and problems- atp i only use it for personal gain

[blizzardfluffykpop]

Bias Spreadsheet Math

Okay, so I have a spreadsheet for my biases because I have quite a few (currently on this sheet: 27) and I like to keep facts about them stored. Just to see what lines up with the other ones. (Side note: None of my biases seem to line up...)

Anyways, I always have to manually put in the age they've turned. And I've had this spreadsheet for like a few years now. And it's tiring...

Cause I'm lazy & okay with math- I made an equation? So, the =DATEDIF() equation only works w/numbers. While Google does have the function for "TODAY" it wouldn't work in said function.

So, if I wanted it to always solve from birthdate to today. I'd have to come up with a different way, so I'd never had to type their ages manually again. I configured a little 'today's date' cell in the sheet. Thus, dubbing "AB2" as the dedicated cell.

And here 'X' will stand for any birthdate/cell w/birthdate. And years will be represented by "Y." After all, that is what we are solving for.

Thus the equation looks like:

=DATEDIF(X, AB2, "Y")

I'll be the first to admit I love math, but as a person who doesn't like to do the same tedious work over and over... This is going to make a nice difference when I look at the sheet again in the future.

Also, disclaimer: I didn't get the idea for the bias spreadsheet, someone else made the original. I have just made it custom to me. It does have some functions from the original, most of them have been scrapped tbh. Especially because this is my third version of the spreadsheet. (I don't keep up w/a lot of groups anymore, so I made a new one to decrease clutter). I don't know how much of it remains? I do have the link to the official one tho.

Anyways- if you've read on this far- and are still intrigued! If you wish to start your own: I have the link to the original and can also link mine! And if you'd like I'd be more than happy to help you set it up!

Idk I'm very proud of myself for figuring it out. It took me a little bit, but algebra was my favorite in school, so it came with ease! :)

(Also, this post marks: 25,000 posts *reblogs & originals* 🥰)