mon-fri

I have a formula that correctly returns if a date is a mon-fri, weekend or public holiday. =IF(A11="","",IF(COUNTIF(Sheet2!$G$87:$DO$97,A11),"Public Holiday",IF(WEEKDAY(A11,2)>5,"Weekend","Mon-Fri"))) I need it to now determine if the day is a mon-fri, saturday, sunday or public holiday. Can...

Hi! New to this forum and to VBA so I'm really hoping we have some experts present :) Let's say I have a list of users and each user has a value for mon-fri. What I want is a listbox with multiselect so I can select multiple users and then the userform should export those usernames J3 and...

Hello all, I was wondering of a simple process to compare schedules to eachother as far as being 100% matched 80%, 60%, etc. For example: A supervisor with Saturday & Sunday off who works Mon-Fri 9:00 AM to 6:00 PM. An agent going to the supervisors team who is Saturday & Sunday off, works...

Hi I have spent SO much time in Excel trying to get this to work but have failed miserably, when I think I'm there, I test it and it fails.... This is the scenario: We pay staff weekly based on 4 different categories of shift as follows (all paid at different hourly rates) which they submit a...