2 or more days in a row

[bam12]

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

 

[Peter_SSs]

bam12

Some sample data and/or screen shots explaining your data and giving expected results would help. At this stage I don't really know what your sheet looks like or what you are trying to achieve.