date & range

I have a worksheet with a long Vba code to run many rules in the sheet - One of these rules is to insert today() date in cell "D11" when any edit happen in cells ("E5 or G5")- the problem is that I face a lot of delay in this rule to apply after many times try and sometimes it run after...

Hello all, I am working on a monthly tracker for work where I have a userform that allows the user to enter data. My last goal with this is to select a month tab based on entered data in the userform. For context, right now I have to manually select the month I want to enter the data to, then...

Hi all, I need help with conditional formatting! I am in the process of making a tracker used to keep track of when certain machines need maintenance. Could someone help me out with creating a formula for conditional formatting that will highlight cells with dates in the month ahead, 2 months...

I'm trying to come up with a formula to determine the number of years, months, and days (in this format) when subtracting from a specific value, i.e. 17 Years, 0 Months, 0 Days (this will always be the same and will not change) For example, I need to deduct 15 Years, 5 Months, 25 Days from 17...

Apologies if this question has been raised before, I did look through the old posts but nothing that got close to an answer for me. I need the count of how many times the ID occurs during a period. But I need to count them uniquely. Here is an example of the data Date ID 22/07/2024...

Okay, here is a brain stumper. (for me anyway). SO, there are 52 weeks in a year. I need to find the first Monday of week 1, not necessarily of the month. For example, January 1, 2025 is a Wednesday. In payroll, it is Monday December 30, 2024. That is the first monday of 'week 1'. I have found...

Hi Some advice please as I cannot get it to work 1) I want cell M4 to do the following, if possible, please: i) If the date entered in cell M4 is equal to or less than the date in G5, then green colour and bold text ii) If the date entered in cell M4 is greater than the date in G5, then...

I am attempting to get absentee points to fall off after 365 days. My sheet has a row with the date. A row with the points. I have it totaling the points in the row but want the points to not be included if its been 365 days. My formula does not work...I have attempted multiple variations with...

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