Forum Discussion
Looking for a formula to not update the cell after is past expiration date.
Hi! I'm creating a spreadsheet where I like to collect all the absences from an employee. Let me explain: For every absence, the employee earns two flags and each one of the flags expire 28 days ...
I really tried to understand your text and formula but don't get it. What do you mean by 'getting reset' and why do they get 2 flags instead of just 1 w/ exp date of 56 days. And more off, I don't get the formula. The picture doesn't show rows or columns so I'm assuming the 2nd flag is row 8 and showing columns A:E. But then when, why, how would E7="". I must be missing something.