year

Hi Everyone. I have a UserForm where the user must update the Public Holidays (South African) for the year. Basically the user must only change the year and then the date of Easter Friday. All the other dates will auto update in the relevant Table ("tblPPH") In this UserForm, there will be a...

I know how do do a simple salary schedule to to calculate year over year salary. I've tried googling, but came up short. Does anyone know of a formula that I can use to calculate year over year salary expense average? I'm trying to create a template to use for new-account bids to factor in...

Hello Guys. A quick and simple question (too difficult for me though). I have a column with dates (Column A). I need to count the number of records that are from the certain year (YEAR formula) and certain week (WEENNUM) without using any additional calculation columns (file is big, a lot of...

Hello All, This is my fist post here so please accept my apologies if this doesn't followthe usual format for asking questions. I have a worksheet which I use to monitor staff holidays and plan resourcesaccordingly. Part of this sheet is a table with a list of about 50 staff on theleft and the...

Hi, The code is shown below. I have a userform with Comboboxes ComboBox1 is MONTH ComboBox2 is YEAR Month is to be inserted into cell A3 Year is to be inserted into cell C3 When i press my transfer button the YEAR isnt shown on the worksheet but the MONTH is entered into cell A3 Please can...

i have a formula "=MIN(D5:SJ5)" but D5 starts at 11/02/17. Now I gotta change it to 11/01/18 since it's a new fiscal year for us....is there a way to make this dynamic? that is, make it such that I dont have to manually look for where 11/01/18 (which is currently cell IS5) and change the...

the title says it all

Morning, The code im using is shown below. I have used a code from another userform where it had two comboboxes & now wish to use it on a worksheet where there is only one combobox. Some info for you. Worksheet called SUMMARY SHEET Year for combobox is on worksheet called LIST which is in the...

Hi, I was wondering if anyone could help me as i'm a bit stuck on the following task. I need to automate the roll-forward of an excel spreadsheet where the year which is being increased by 1 is within text. ABC2019ABCDEFG will need to be roll-forwarded to ABC2020ABCDEFG. The issues I'm...

I have a sheet with pay rates. There are about 80 different pay rates that differ for age, gender and competition type. Rather than have a sheet with a rate for every day of the year for the past 12 years I'm wondering if there is a way to do this with effective dates. So when I'm looking up a...

Hello, I am hoping to get help with a formula that can calculate PTO accrued by a specific date. For example, If I wanted to know how much PTO Jane will accrue by 11/16/2019, what is that amount based on how many hours Jane receives in a year. Our current formula (below) doesn't work for...

I have a spreadsheet which contains pricing information which I refer to when creating estimates. When I enter the pricing information, I record the year I entered the amount. I'd like the spreadsheet to show both the escalated rate and also the escalated rate. Unfortunately, escalation does...

<tbody> Name Address Description John 2nd Street, NY A1A1 is 35 year old, A1A1 is NewYork .... Kevin 4th street, FL <tbody> A1A1 is 35 year old, A1A1 is Florida .... </tbody> Manly 5Th street, NY <tbody> A1A1 is 35 year old, A1A1 is NewYork .... </tbody> <tbody> A1A1 is 35 year...

Hi, can anyone provide guidance/examples on rank.eq formula with multiple conditions? I am generating pivot table for Company A filtered by year, and I want to set up a linked table - table 2 (so row values change when my pivot filters change) to display rank.eq for each row value generated in...

Hi everyone, this is my first post here. I consider myself an intermediate skill-level with Excel, and I use it at work quite a bit, but right now I'm stumped. In the simplest form, I'm trying to figure out a formula that will multiply a cell by a another cell which is a percentage, then round...

Hello, I have 3 tables with 12 columns each (Actuals Jan-Dec (A1:L100), Forecast Jan-Dec(M1:X100) and Full Year Jan-Dec(Y1:AJ100). I would like a macro to perform following: Based on weather cells A1 through L1 > 0, copy each column from Actuals Range to Full Year Range same period. So, Jan...

Hi I'm trying to forecast my unit sales for the following year. I have last years data but I'm at a loss as to where i begin. My data is below along with what i expect the market changes to be. <colgroup><col><col span="12"></colgroup><tbody> Monthly Data Jan Feb Mar Apr May Jun...

Hello, first of all thanks for your help. What I want to do is to compare the cumulative sales from working days since first of the month to current date vs the sales of the same quantity of working days same month last year. Lets say today is September 4, 2019 and we work from Monday to...

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...

Can someone assist with an Autofill code that autofill dates in column A for a specified year (i.e. 01/01/2019 - 12/31/2019) Thank you kindly