attendance/ sick days counter
Hi!
I want to create a sheet that will allow me to track the percentage of my sick days (i can't be over a certain number so it's important for me to know how many days i have left) from the total days, so e.g. when i have 10 days of work and miss one it would be 10 percent. what i don't get is:
\- how do i add a button that will automatically add 1 to the number of sick days so i can just click it when i do have a sick day
\- is there a formula that automatically adds 1 to the number of total days when it's a weekday, so from mon-fri e.g. when it's been 20 days of school so far, every day it will add 1, so 21 on monday, 22 on tuesday and so on. that will allow me to keep track of the relative percentage (as i believe it's called? idk, i'm not a maths expert lmao) rather than just the absolute percentage of the whole academic year.
I'm completely new to sheets but i've been playing around for a few hours, so far no luck.
if anybody has any tipps, formulas or websites with good formulas (so far i've only been able to find pages like "30 basic formulas everyone whould know", no extended list or anything. i've looked here in the subreddit for similar requests or even parts of it but haven't been successfull so far.
thank you in advance!
side note: i'm aware that AI could give me an answer in like 2 secs, but i'm opposed to using it out of environmental and moral concerns.