date & range

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

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