Hey yall. I have a problem that has plagued me for a year now and I haven't been able to find a solution. In my Excel sheet, I want the "Days off" values hidden until a value is put in for "Days Worked". (That part sounds simple) What I can't figure out is how to get a sum of the "Days Off" count, without including the days in future months. What I mean is, right now my sheet shows that I've been off 274 days this year. Obviously this is not correct.
Hopefully I explained this well enough and yall can give me a hand.
Thanks,
Days Worked.xlsx
Bookmarks