IF COUNT function

[Glenn]

Hi, for payroll purposes I need to know if my staff have
worked at least 15 days in the last 30 in order to be paid
for a statutory holiday. (Manitoba, Canada). I already
have payroll worksheets, but each month is on a separate
tab and I don't know how to build an IF COUNT function
arcoss worksheet tabs or if another function might work
better. Can anyone help me? Thanks, Glenn

 

[JE McGimpsey]

I think you probably need to describe how your data is laid out a bit
more, along with how you want to establish "the last 30" - should it
update every day? or only when prompted by the user?