i need a little help on this
trying to update a vacation/personal day spreadsheet
Each personal day used that was not scheduled is an occurance, unless it is 2 or more days in a row, which will only count as one occurance.
Is there a way to do this with excel to check for 2 or more days in a row and also maybe check another cell to see if day was approved by maybe putting an "A" in a cell.
There is also one more thing about this, if you take a personal day, this comes off the occurnace tally after 90 days
Right now i am using the formula below to do this
column H is where I enter the date of the personal day..
Did use sumproduct before but had to change because of other formulas in sheet
=COUNTIF(H$7:H$44,">"&TODAY()-90)
Thanks in advance for any help
trying to update a vacation/personal day spreadsheet
Each personal day used that was not scheduled is an occurance, unless it is 2 or more days in a row, which will only count as one occurance.
Is there a way to do this with excel to check for 2 or more days in a row and also maybe check another cell to see if day was approved by maybe putting an "A" in a cell.
There is also one more thing about this, if you take a personal day, this comes off the occurnace tally after 90 days
Right now i am using the formula below to do this
column H is where I enter the date of the personal day..
Did use sumproduct before but had to change because of other formulas in sheet
=COUNTIF(H$7:H$44,">"&TODAY()-90)
Thanks in advance for any help