vacation

Hi guys, Already tried search, but could not find an answer to my question. Is there a way to have the function NETWORKDAYS to use two list, one of holidays and another one of vacation days? I could not find an answer to this question, so, I think I will have to use only one list of "holidays...

Hi guys, Trying to check if a date is between a range of dates in a table with date ranges. So, I have a table with two columns, col C is first day of vacation and col D is last day. And I'm trying to come up with a function to tell me if a given date is inside that range. I'm toying with...

Hi Cummunity, Needing some help to concatenate row values being retrieved from ACCESS Database. INstead of writing to multiple rows, i need to concatenate all the record set values and write it to a single cell. Here is a view of part of my code: Currently there are two rows in the database...

First off, I apologize if this question has already been asked and answered! I am looking for a formula to determine employee vacation time. Our VT is distributed in hours not days, and no hours can be carried over to the next calendar year. My spreadsheet already has employment start dates...

Hello Team.. another request.. Been thru similar requests threads..none matched my requirement. Based on the below RAW DATA, I want to know how many staff I have at any given time. SAMPLE RAW DATA: <colgroup><col><col><col><col span="7"></colgroup><tbody> EMP ID Emp Name Supervisor 14-Oct-18...

I have a vacation calendar to create for 2020 and I use NETWORKDAYS to give me number of days that a person needs for vacation. For example, NETWORKDAYS formula applied to a vacation from 9/2-9/6/19 yields 5, which is correct. My problem is that some employees work on the weekends, so applying...

Hello All, If anyone can you assist I would be greatly appreciate it. Ex.: I have a list of 10 Employees that do various jobs. Of those 10 employees, 3 employees cover the job of the person(s) on Vacation. The maximum number employees on vacations is 3. I would like to show (in a excel...

I have a main worksheet that draws info from another worksheet called vacation. Vacation has the amount of vacation time in hours the employees get each year and also vacation carried over from previous year. Main worksheet has 31 employees and their attendance for each month in 12 tabs (each...

Hi, Can someone please help me with this formula? I have this info: Column A = employee name Column B = hiring day Column C = Original vacation days per year (15 or 20) **Column D = Xtra vacation days Column E = Total vacation days (15+column D) For every year worked after 4 years...

Hi, Can someone please help me with this? Every month I have a raw data report with these columns: Employee, Leave type (vacation, statutory holyday, other paid leave), number of hours, week, day,month. Instead of doing a pivot table, I would like to organize the information with formulas...

Hello! I have been assigned to making a vacation accrual spreadsheet that will auto calculate vacation time for the coming year based on hire date. The parameters are complicated and I am stuck on how to do this. 6 months after their hire date they start accruing vacation at a rate of 3.07...

i need some help fixing a spreadsheet to helps to calculate vacation accrual

I have been asked to calculate vacation accrual for the end of the year. vacation is earned at the hire date. I was trying to calculate how much is earned monthly.

Hello all, I am looking to see if someone will help me create a macro that would flatten a data table (or move the data from rows into columns) by Name and Activity in excel. Basically I need to go from this (but there will be many different activities per name): Name - Activity - Start...

I've got two sheets in my workbook. One is a list of all employees on a project, the other is a list of employees currently leave. I need a function that looks in the "Employee ID" column of the employees on vacation, and if matched, returns a value in another column indicating their status...

Does Excel have a function to convert hours off into days (8 hour day) and minutes? For example If I have 51 hours of vacation If I divide that by 8, that equals 6.38 days off So I have 6 days off + .38 of a day. How would .38 equate to hours/minutes?

https://www.dropbox.com/s/eh3nqsiucqw4sqz/VACA.xlsx?dl=0 Can anyone assist with the following vacation accrual attached is a dropbox link for what I have so far. I need to populate the accrued vacation based on the accrual date which we get 10 hrs a month or 120 a year. I need it to stop...

I am trying to determine the number of people (List of Employees) on vacation based on their vacation start date and end date (Employee Leave Tracker). I need to account for each day of the year and ensure a certian percentage is not absent. I have tried: =COUNTIFS('Employee Leave...

Hi All, I need some guidance and ideas on how to Fill each Employee names if their status is "Vacation Leave" to the corresponding date of the calendar sheets. For example on the image below, In row 3, Robert Downey Jr. and Chris Evans should be filled to January sheet (cell G8 and G9) in...

Ive got a nice spreadsheet set up with all the info I need, but I cant get the formulas to tie together correctly to calculate properly. Im getting very frustrated! Please help. :confused: Why cant we attach excel here?!?! <colgroup><col><col><col><col><col span="3"><col span="3"><col><col...