IF COUNT function

  • Thread starter Thread starter Glenn
  • Start date Start date
G

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
 
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?
 
Back
Top