vacation

Hey guys! Im new here and am getting really frustrated trying to make my formula work. I need to accrue vacation time for my full time employees. At hire date anniversary, they get 40hrs and accrue 3.33hrs per pay period. I need to figure out the formula for my balance column at the end, AF6...

Hi everyone, I'm stuck on what looks like a pretty simple formula. What I am trying to do is, I have a work schedule for a production team on one tab. I also have a vacation listing on a second tab. I am trying to write a statement that will say to look at the employee's name (A6), look at...

I'm working on rebuilding a yearly vacation planner (based on May-April, our vacation planning year) that our organization uses and am looking for help on conditional formatting. I've been asked to keep the previous formatting, which is why I have the pivot-based calendar appearing in the top...

I have a tab in a spreadsheet that lists employees taking their vacation in advance. If an employee accrues a week of vacation late in the year and there aren't any more weeks for them to pick due to the limit of vacations being reached for that week, the company will allow them to take it at...

Hello, so I am looking to see if a formula or other could assign an asterisk to when someone will be due a new vacation in the year based on how long they have been with the company. There are several conditions though, if they are Union employees or non-union, and in the case of Union depending...

Hello all, I am trying to hide a range of dates until I am within 2 weeks then have them show up. For example: Jan 1-3, 2018, Feb 4 - 9, Mar 1-6, 2018 (with actual calendar days) to remain hidden on my worksheet (these are potential vacation days for me), then when I am within 2 weeks of the...

Hi I need to sort out one thing For example i have four option ("LEFT" "Vacation" "Final Settlement" "Working") on cell ranging from G4:G321 and when i select LEFT OR VACATION the cell i need to show show 0 other wise 30 on cell ranging from J4:J321. I had this formula on the cell ranging...

Hi All, I have an excel sheet with two Columns, Organization Name and Type. I would like to merge all the types for a particular organization into one single row. Example <tbody> <tbody> 3Bridges Community Before School Care, After School Care and Vacation Care </tbody> <tbody>...

Hi, I need a macro to update values from input sheet to master sheet. Input sheet having three columns emp no, vacation date and rejoin date. Macro has to find emp no from master sheet and then find vacation date as per once it found macro should update rejoin date next to vacation date column...

<tbody> <tbody> S M T W T F S Total S M T W T F S Total S M T W T F S Total S M T W T F S Total S M T W T F S Total 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 1 2 3 4 </tbody>...

Hi, Need a help on following, I have 4 selection on column G which includes Working, Left, Vacation, & Final Settlement. I need to Color cell column from A TO B if i select Left, Vacation or Final Settlement. Can you help me on this. if The cell H value is left or vacation the cell A & B will be...

hello all i have a formula which is the following =SUMPRODUCT((OFFSET($A8,0,1,1,372)<>"")*(OFFSET($A$3,0,1,1,372))*((OFFSET($A8,0,1,1,372))=NL$5)) A8 = EMPLOYEE NAME A3 = the current month NL = an infraction or paid time off my question is how can i get this to equal multiple arguments so...

Greetings all :) hope you survived new year :P I have a 2 part question: Is there a way to permanently display track changes in a separate tab WITHOUT using VBA + is has the latest changes written My current formula present in cell B54 checks the name of the employee and the month and if...

Hi all - new to the site, but am hopeful you can help! I found some options that are similar, but being an excel newbie, I wanted to get specific answers to my scenario so things don't get messed up when I attempt to plug in the formulas :laugh:. So, I need to calculate vacation for each...

Can anyone suggest an easy formula for the following vacation accrual: 0-1 year 4 hrs per month 2-4 years 8 hrs per month 5-10 years 12 hours per month 10+ years 15 hours per month Accrual is based on date of hire

Hi All, So I have been pulling my hair out for a few days now trying to figure out how to do this, but no matter what I have tried, it never worked. So I thought my only remaining option is to put it to the experts here on the forum for some help. I am attempting to improve our small company...

I need help with my current employee and sick and vacation tracker. Vacation starts over on the anniversary of hire date. I have one spreadsheet set up to track days they are absent. I have a SUMIFS formula to return that info to the summary page to calculate how much time taken and how much...

Hello, I am in charge of the tracking of Vacation time and I am having a really difficult time creating a formula. As I am not excel proficient. I would appreciate any help (: Our Payroll works as follows: PAY FREQUENCY -- 2 Times a month (on the 15th & Last Day of the month) 20 Days per...

Hello, I have created a corporate calendar where the rows contain the days of the month and the columns contain the employee's name (14 employees total) and the cells may contain V for vacation when the employee will be out of the office. I do not want more than one employee to take vacation at...

Hi, Im having a problem where I want to compile data from several rows into 1 single row. The data in this case is time and attendance data to upload into a payroll software. There are 9 different columns as follows: Code Code nr Code name Employee ID Employee name Number (hours/days) Type...