date range

Hi, I require a formula in C18 (Red) That uses the date in C18 (Green), searches it within the date ranges of Columns D and E, and produces the result of Column G depending on which Row that date falls on. Thanks in advance.

Hi, I’m hoping you can help me, I stupidly said I could help a colleague with his excel sheet but this is proving way beyond my knowledge. I have multiple sheets for tracking spending from different budgets. On the final sheet I want to be able to pull all the row information from across all...

I'm trying to create a new table of dates of the first and last day of the month. The date range for this new table is from the "Date Created" field of a separate table (Table 1) which is from an external data source. I'd like the new table to be dynamic so that as Table 1 is updated, the date...

Hey Guys, I have a certificate column and its helpful to have the start date and the end date but id like to be able to use conditional formatting so if the date range is within 5 days of expiring its orange and if its expired its red. Here is the data A1Certificates201/12/22 -...

Hello all! I am working on a very large spreadsheet and need to calculate the mean and standard deviation for each month of 2021. I've figured out the formula for the mean but the standard deviation isn't giving me the correct information. Cell References $D$1 is the year (2021) $D$2 is the...

Hello!! I would like my column of dates to have 3 colors. Let's say that the date expires after 12 months. Based on the current date 6/1/2022 (or current year) Ex. The date entered is 4/13/2022 (this would be green) Ex. The date entered is 6/15/2021 (this would become orange) Ex. The date...

Hello, I'm working on trying to pull a unique set of project IDs from a table that identifies certain aspects of projects such as a "completed" status and whether or not that status is between a certain date range. Unfortunately I keep getting a #CALC error which I assume means that it's trying...

I want to assign a color to a cell based on there being an event that falls within a specific date range. As shown below, event1, falling within the week of July 4, would cause F3 to be blue, since it has category1. So the cells in range F3:I5 would be colored based on a running list of events...

I have a very large spreadsheet with headers (180k+ rows) with unique ID's in A, start date in B, and end date in C. There are multiple rows per ID and the start and end dates overlap in a messy way. I need to find any gaps in the date ranges for each ID. I've written a few different formulas...

Hi all, I'm wondering if anyone is able to help me. This is driving me crazy! I have multiple charts which contain environmental monitoring data: These are based upon data pulled from colums containing dates sampling took place and then adjacent columns containing microbial colony counts. for...

Hi All, I have a list of events with start date and end dates (sometimes these are single day events) but I need to know how many working days appear in a certain month. For example someone has taken a holiday from the 29th of January to the 5th of February 2021 this is 6 working days but only...

Hi, I'm wanting to trigger an event between certain dates. I have a named range called "Licence" on the sheet named "Lists". Within "licence is a date. For the full week before this date is met I want a message box to open, after the date I want the code to be bypassed. I was trying to use...

Hi All -- I am just looking for some help on the following issue -: I am trying to find a way where, I can return the week number, within a specified date range, based off an entered date. In the example below, if I enter a date in column E, column F will return the Period for which that date...

Hello, I am trying to highlight a collision if the date ranges in columns B and C coincide as well as the values in column F. The collision column G should then be either red, or indicate yes or an x. How would I express this? Thank you!

So I have date in the format Value Start Date End Date 40 14/10/20 05/11/20 50 01/10/20 31/10/20 Assuming the value can be spread evenly over days, I want a sumif function that tells gives the following output (ie for Oct, 17 days of the 22 days of 40, PLUS 31 days of the 31 days of...

I have a 75-page spreadsheet that I want to be able to print a page or a range of pages without having to specify the normal way. Is there a way to be able to have a dialog box or have a cell dictate which page(s) I need to be printed?

Hello Forum I am needing some assistance bringing back multiple results into one cell if a match is found based on a name match and a date falling within a range on another sheet. Sheet 1: this is my results sheet Column A = list of names Column D = start date Sheet 2: this is my lookup sheet...

Hello All! I'm trying to create a formula that counts the number of unique dates within a date range based on the type of item. I've tried several different formulas and researched ways to do it, but each formula was so specific to the poster's specific problem, that it did not work so I...

I've tried using =NETWORKDAYS and it does work, but it excludes the start and finish dates. Is there a method that will count weekdays in a range while including and the start and end in that range? example: Start date: July 8th, 2020 End date: July 15th, 2020 NETWORKDAYS: 4 Desired count: 6

Im trying to show the Top 5 performers within a date range using the units per hour (column G) At the moment im using the following formula (for first place) which gives the answer i need but you have to manually put in the date range. =LARGE('Sheet 1'!$G$2:$G$60,1) I want the user to be able to...