start and end

Hi, Employees are often rehired and I need to determine which start date to recognise as 'continuous service' for the purpose of service awards. Prior start dates are only recognised as continuous where the break in employment is 90 days or less. I need to determine which start date to...

Hi there, Here is my example, I got a chunk of data in sheet1 here, it's a task list contain start and end dates for each task. (it's comes from my calendar as power querry so it may fill up any times) ABCD1Start EndMy TaskPriority222/10/202225/10/2022Task 1LOW323/10/202224/10/2022Task...

Hello !! I’m trying to make a similar graph to the one attached . Is there anyway to do this ? I have a start and end time and criteria (instead of weekday I have area )

Thanks for taking the time to read my thread. I tried to create a simple userform but i'm having trouble scrolling through it. Would I be better off creating a recordset? Some of the data is shown in the form and some is submitted. I'm trying to move forward, backwards, first record and...

Hi, I would really like to get some help on this model that I am building. Imagine the following data <tbody> Customer Amount Start Date End Date Frequency Jan Feb Mar Apr May Jun July Aug Sep Oct Nov Dec Jan 18 Feb 18 John Pree $2000 05/02/17 05/02/18 4 500 500 500 500 Mary...

Hi, Good day to all of you. Can someone help me with my excel problem. I've tried pivot table but it doesn't make sense, the result is not really what I wanted. If someone who has a good heart that can help, I would appreciate it from the bottom of my heart. So, here it goes.. My data is look...

Hi All, I have a list of contracts with all different start and end dates. Could be any date. I would like to see per contract for which quarter(s) they are valid. Also if a contract is just 2 days open in a quarter, I need to mark them as YES open in that quarter. See below table. Any nice...

Hi all. TIA for viewing/helping If column A1 I need to find a start date B1 is an end date in the following format: 02/03/2014 C1 is a duration of employment typed in the following format: 11 yrs 6 months How can i get a start date (Column A) based on the column B and C data. Many thanks

Hi, Andrew recently gave me a hand with an Excel formula I had been working on to automatically construct an SCCM collection query from a list of computer names entered in column B of an Excel 2010 spreadsheet (found this thread here...