date & range

I've read a lot of threads and usually manage to find my answers, but haven't quite managed on this occasion. I have a period start date in b1 Period end date in b2 The first date of the biweekly occurrence in b3 Based on the payment being fortnightly, I need to calculate how often it will...

I have this vba to auto open and find today's date from column A and select the cell next to it in column B Private Sub Workbook_Open() Dim myDate As Variant, rng As Range Set rng = Range("A1:A68") Set myDate = rng.Find(What:=Int(Date), LookIn:=xlFormulas) Cells(myDate.Row, myDate.Column +...

Hi, and thank-you in advance for your assistance... Column 'A' contains a set of order numbers. These may be duplicated if a sales order has more than 1 product. Column 'B' has the date of sale in every row regardless of whether the order number is duplicated or not. So, i am trying really...

I have begin date in B2 cell and end dae in a cell C2. I want to obtain the value yes, if the begin date is between the 18th of the previous month and the 17th of the month of the end date. The verify end date is the 29th of the month. Example: I've tried several ways, but it never validates...

Best, I have an employee roster where I want to have dates filled in for a specific shift based on another sheet. Now Vlookup shows the first best match, however, the idea is that based on today's date these dates are filled in. In short: The particular person's schedule should be shown...

Dear Excel Community, How can I check if a date range passes through a month and give out the number 1 if it does. Im an intern at a company and every month i have to give a report for the workers council. In this report I have to count the number of interns and bachelor/Master thesis...

Hello, I'm trying to figure out how I can select a range based on a date within the current week. Example of selection… The order I'm trying to step through is the following: 1. Declare Friday as a variable to store the date using a formula: =TODAY()-WEEKDAY(TODAY(),16)+7 As of today...

Hi All, I've been searching through this forum and others for a few days, and with my still limited VBA knowledge, I've been unable to find a VBA script that can assist me in achieving my goal - most of the solutions are for preset future expiry dates. To the question - I have a master...

Hi All, I currently have a function that identifies which dates between two dates are Saturdays. What I also need to know though, is how to work out if any of those Saturdays appear in a list of specified dates e.g. Leave//Holidays list of dates. So the below example shows what I'm trying to...

I have two tables. In the first table are the rates by resource (columnA) and the MonthYear (ColumnB-Y) In another table, table 2, where I have the resource (columnA) date MMDDYYY (columnB). I need for table 2 to look up and match both the resource and date from table 1 and return the rate...

Hi everyone, I'm trying to troubleshoot some issues I'm having with a formula for finding working days in each month in a given date range. In the example above you can see the formula I'm trying to apply to my "real" sheet. I have no trouble getting it to work in this "test" sheet, but as...

I am trying to organise an on call roster where an individual is selected for a seven day period. This is in a table with name - start date - end date of when they are 'on call'. In a second sheet, I want a second table where people input the dates they are unavailable to be on call due to...

Effectively, any of the office 365 equations *IFS do not seem to dynamically update when new information is presented in the range, they stick to the first answer given and then just repeat. The real formula is quite long and it works well enough (though I'm sure there are faster ways). I have...

Hi, I have a job sheet that enters the totals of a day. I need to average jobs completed each day for tracking. so sum each Tuesday and average against each other Tuesday. I have used the averageifs function but that is averaging the jobs within that day. This is the results page, with the...

I have a set of data (see picture attached), where different projects have several dates, even within same month (A3:B16). My goal is to build a ''calendar'' that will show Projects and their first date that will fit within the selected month. E.g. in the picture: I want to see the projects...

Have tried searching the forums but can't seem to word my question correctly. Here is a basic table:- Date Type Product Qty 01/12/2022 Order Blue Shirt 1 02/12/2022 Order Blue Shirt 1 03/12/2022 Order Blue Shirt 2 04/12/2022 Order Yellow Shirt 1 05/12/2022 Order Blue Shirt 1...

Hi all, I wondered if there was a clever/efficient way of checking if multiple columns with dates in, fall within a date range, see below table. I want to check if any of these dates fall between the 25/12/2022 and the 02/01/2023. I know I can do repeating if statements, but thought I'd check...

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

Hi, I am new to the site but hoping someone can help with ease... I have a tab in a workbook that includes a list of dates when a companys vacancies were given approval - column E. I have another column that provides for the date when the vacancy was filled - column O. I am looking to create...