# accrue

1. ### Pto calculator

hello all i have a few formulas running and the breakdown is below. I have a page which is called PTO Hour Settings" which the sheet "Employees" references. A manager is to input what information applies to his account in the PTO hour setting page so this formula needs to be universal. The...
2. ### Dynamic Formula needed

Hello, I am looking to see if anyone has a nice formula for a problem I am running into with my PTO accrual sheet. Where I am having issues, is when the anniversary date of the employee comes and the accrual would change. The problem I am having is, for instance, if someone started on May 5...
3. ### Date formula

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...
4. ### Vacation / Paid Time Off Accrual

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...
5. ### Copy a Range of data from an extensive list based on Criteria from a specific column

Hello guys, I have a list of purchase orders (PO's) in sequential order (one below the other) all in excel that begin with a company name in Column A, "Cardiac.." and ends with a "Signature" line also in column A. The PO's data are occupy Column A to Column I. Each purchase order is of...
6. ### First Payday Calculation using Hire Date (Bimonthly Payment)

Hello Everyone, I want to get the first payroll of the new hires by using their hiring dates. The pay is given on the 15th and last day of the month. I am using the formula IF(DAY(Hiring Date)<=15,DATE(YEAR(Hiring Date),MONTH(Hiring Date),15),EOMONTH(F4,0)). It gives me their first payroll to...
7. ### Vacation/Sick Time Excel Spreadsheet help!

Hi! I'm not completely new to excel, been using it for years but for simple things. I can do some formulas but that's about it. So I have no clue how I can get this done! I saw a thread similar to what I need but with different specifications...

### This Week's Hot Topics

Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
• Block certain cells in condition met in cell A
Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
• IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
Hi, Below formula works well, =(INDEX('PRICE LIST'!\$C\$7368:\$C\$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!\$A\$7368:\$A\$7679)*(WORKSHEET!P28='PRICE...
• Match data from 3 columns to return data from the correct 4th column
Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
• VLookup
Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
• Defining a range
Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back