leave

Hello, I am trying to make an annual leave tracker for my partner, which displays the following things. Total Annual Leave Annual Leave Taken(Historic) Annual Leave Taken(Future Dates) Annual Leave Used. The issue I am finding, is that because her annual leave is calculated in hours, like...

Hello Excel Users! I need some assistance on an array formula for a summary table that will show multiple results for a set of criteria: Selected Employee Selected Year Only Leave Types: Call Off, In Late, Leave Early The first formula I tried with the leave type conditions but it said I was...

Can someone please help me to write the following formula? Conditions: if A1 and B2 are blank and A2 and B1 are NOT blank If True: = A2 If False: (leave cell blank)

Hai , can any one help me to solve this issue Am creating one leave plan template , I want to restrict the entry if the leave is crossing above the target . In my template row is employee names and column follow dates, And for leave plan i put code for leave as “V” and total count by using...

When a Form is loaded is it also considered "On current" or does the user have to leave the form and come back to it to be on Current?

Hello, I've below two sets of data in different excel sheets 1) Training data - it contains User ID, Training Start date and Training Due date 2) Leave data - it contains User ID, Leave Start date and Leave End date User can have multiple training which are assigned through out the year and...

Just looking for a little help with this formula as I cant seem to get it to work. Basically I'm looking to return an F if the "PP - 3" is greater than 0. Returning a P if "pp - 1" + "PP - 2" is greater than 0 and if when you add all three together it returns a 0 then leave the cell bank. If...

Hello, I have a problem with a formula in a staff holiday tracker. The tracker has the employees names in Coloumn A, from row 6 to row 15. Coloumns B-NI correspond to the days of the year: each employee enters the leave codes, as per the table below: <tbody> Leave Name Code Sick Leave S...

Hi all I have been asked to make a chart for staff in an office. Currently there are approximately 111 members of staff, however this is likely to increase in the coming months. I have prepared a workbook which has sheets for 2019 and 2020. Each of these sheets has the days of the year across...

Hello all Can I have some help please on this I want to include in the formula below [IF TODAY() > TODAY () Leave blank [Range("C23:P34").FormulaR1C1 = "=SUMIFS(Sales!C9,Sales!C5,R21C,Sales!C16,R22C,Sales!C21,R4C3,Sales!C24,RC2)" Is this possible please

Hi, I have used iqy files for excel on mac. It loaded the table results and i was able to format it but it left the hyperlink as needed. I decided to try power query and used my windows version of excel and I am able to make the connection and pull the data. Much easier to deal with. But the...

Morning, I am looking for a code which will show a msgbox to advise me the character count in the active cell is anything but 17 Some info for you. Worksheet is called MC LIST The code will only need to work for column B The range would be B6 & down the page Example, So i type in cell B9 15...

Hi, I need urgent help to develop a formula for the following: I have an extremely large data set, approximately 600,000 rows. There are a number of variables that need to be considered but basically I need to delete positive and negative numbers (hours paid) per employee (employee id), per...

Hi can anyone tell me if it’s possible to have a two TextBox 1&2 with two SpinButton 1&2 that sits in a userform so when the user presses the SpinButton 1 it drops a time format into say cell A1which would be known as leave and by pressing SpinButton 2 it drops a time format into say cell A2...

Hello Everyone , I am trying to create an excel application for leave, I have got the template online and its perfect for me. I want to create a validation while applying leave and need your help for this. While applying for leave the system checks the employee column (Employee are divided...

Hi can anyone please help I have the following VBA Code that works great but what I know would like to do is rather than the code copy the first 4 cells on a row when I double click, let’s say cells A1-A4, can the code not touch and leave cell A3 alone . So even if I was to modify the code...

I have a conditional formatting that shades cells based on my criteria, however if the cell already as shading I want to leave it as is. How can I do this please? Thanks

When I open a workbook, it asks to connect to links. Is it possible to remove them and just leave the values in? Thanks

Hi Guys, I'm new to excel and I took up a time sensitive assignment assignment and I really appreciate any help on this. <tbody> Start date (input) Eligible Months (input) Age 50 (Input) Age 55 (input) Rule62 (input) Age 62 (Input) Leave end date 06/1/2019 12.5 7/1/2014 07/1/2019 09/1/2019...

Hello, I am working somewhere that i am entitled to 2 days off per week whenever i am taking 1 day off per week 1 day needs to be added to my annual leave whenever I am taking 3 Days off per week 1 Day needs to be deducted so i am looking for a formula that will count in an array of 7 cells...