holiday

Hi, I have a (what I thought was) very simple line of code that is causing my macro to error if the macro is run from a different sheet to the sheet that the data is being worked on. I originally defined it within a block of With Sheets... code, but when it errored I defined the line itself but...

Hello All, I have a workbook that is used to track employee absence. There are 13 worksheets, 1 for yearly totals and 1 for each month of the year. Using CF, I am filling cells that equal holidays but would like to add an "H" to each cell in each column that represents a holiday. Right now...

Hi All, I have a spreadsheet that populates the employees time and attendance. I am trying to create a new tab that will only pull the data for lateness's from the main tab. <tbody> Area Badge Payroll No. Name Basic x.1.25 x1.5 x2 O/T Total Late Holiday Sickness Bank Holiday 04 Unpaid Holiday...

Hi, I have a sheet "Planner" where I can input the holidays taken by employees. All these sheets currently work fine as they are if I were to input data manually. What I am looking to do is auto populate sheet "Holiday Overview" cells C4:N28 with the hours holiday taken which is based on the...

Hi, wish to ask if anyone could help me draft a formula for the following case: <tbody> Date Day Malaysia Hong Kong Dealing Valuation 1/1/19 Thursday Dealing if Friday is either Malaysia or HK Holiday 1/2/19 Friday Dealing if Monday is either Malaysia or HK holiday 1/3/19 Monday...

Hi all In cell J4 I have the date 01/11/2018. In cell B15 I want to return the date of the first Monday in the month of November (calculating off the date in J4 (which will always be the first of the month)) BUT where the Monday is a Bank Holiday return the date for the Tuesday, if the bank...

Hello to all, I have a calendar and I am looking for help to show stat holidays I have a list of days and what I am looking to do is highlight the cell to show the holiday on the calendarcan so one show me the way it would be a big help thanks

Hello, I have a document (shared) which we use as a calendar and to keep track of people and where they are. It has all 365 day on it and with over 100 people. I would like a vba to search the document and change the cell colour based on the value. For example: Red if someone is away on...

I have an elaborate payroll budget sheet. I need it to now calculate vacation & holiday liability Starting with the holiday liability I need to to show was our 2018 liability by employee based on their start date, but I also need to not calculate days if they were terminated. Someone who is over...

I'm working on a gantt chart where I want to be able to determine the number of "work days" which occur as of a certain date (which could be a weekend or holiday start). I have to subtract non working days such as holidays, which are listed in another tab. The function I am using is WORKDAY()...

Hi All, I hoping for some advice on how to make a team planning board which reduces the employees holiday entitlement when a holiday is added to the board. Please see below picture to get an idea of what I am looking to create :) - the sheet only needs to capture holidays as a reducing value...

Hi All I am hoping that someone out there will be able to help me. I am looking tochange a nested formula to a macro due to the amount of conditions that need to be met. I have an export out of a system that is rather "ugly". This schedulehas stuff in like holiday, Bank Holidays, Sickness and...

hi, in Week 2 column, i have column Holiday (I column). In week 1 tab under same workbook, i want to add another column next to column I, if there is any holiday in Week 2. Else end if. not able to get it with below. note: Macro to be moved to next step, once column is inserted. Else it will...

Hi I have a staff planning tool which I have created in excel Database. Is fed from a data input sheet, and houses formulas to work out lots of variables. Sheet 2 is a list Column A - Employee Name Column B - Inclusive Holiday Date From Column C - Inclusive Holiday Date To The...

Hi, I have set up a pay date sheet which shows when monthly pay is due up to 2030. I want to bring the date forward to the prior working day if the pay date falls on a weekend or bank holiday. Bank holidays have been set in a range called "Hols".. I can get it to move the pay date to the...

Hi Guys, I have an export which gives me holiday start and end dates e.g. 01/08/2018 - 20/08/2018. I need a formula which will enable me to look at all the dates in the range and enter the value 1 in each corresponding date column on my holiday chart. Can anyone recommend a good formulae for...

Hi, I update a roster for the entire month in the attached format and intend to capture shift details. Row 1 indicates the holidays marked as 'H' and row 4 captures the individuals working in the night shift. For costing purposes I want to count how many times BB has worked the night...

Trying to build a sheet to assist in calculating available working hours vs required hours for a job. Please help with a formula that will calculate Columns D and E based on the logic below: Sheet is setup like this: <tbody> Date Day Status STD HRS OT HRS TOTAL HRS 2-Jul WEEKDAY...

I have a table with a Date column that has the beginning of each (U.S.A) work week, which starts on a Monday, like 7/2/2018, 7/9/2018, 7/16/2018, etc. In another table I have a list of U.S.A Holidays, for example 7/4/2018 (Independence Day), 9/3/2018 (Labor Day). I would like a custom column...

I have searched days to find an answer to this riddle. I've tried Lookup, HLookup, Vlookup, Match, Index with no success. Make cell A1 = "Holiday" if date in cell B1 matches a date of Holidays in a range of cells C1:C25 Please advise, Thanks in advance.