falls

Hi, I would like assistance with the below query please. If I have a specific date, I want to create formula, which flags which period the date falls into. So for example if the date is 30/08/2018, I want to have a 1 under the cell with the date 31/08/2018, if the date was 15/09/2018, I would...

I've searched for something to do this but haven't managed to find anything. I'll be displaying a userform on a TV in the office and one of the labels will contain a "days to go" value. When this value falls say below 7, I want the text to change to red then back to its original colour, is...

Hello I wonder could someone help, I seem to be missing a trick. I have a variable which hold the following information. Lets call it variable1 ActiveSheet.QueryTables.Add(Connection:="TEXT;C:\Users\keames1\Desktop\Configuration Item.csv", Destination:=Range("$A$1")) If I then say With...

Hello, I am trying to list out the days of each month for every Monday and Friday in a given year. I have cell A1 contain a year, for example 2018. Under the year beginning with B1 will be the months listed out. The row below the months, beginning with C1 should list each day of the month a...

Hey Guys, I'm trying to output the dates of the weeks (Monday to Sunday) of any month given the following criteria: First week of month is if the first Thursday falls on the first week of the month. and correspondingly the last week if the next month's first Thursday falls on the first week of...

Hey Guys, I'm trying to output the dates of the weeks (Monday to Sunday) of any month given the following criteria: First week of month is if the first Thursday falls on the first week of the month. and correspondingly the last week if the next month's first Thursday falls on the first week of...

Hello, The formula counts the number of occurrences if the IDs are Unique and falls between certain dates. I also want to include the sales person into the mix. In the below example, the results should be one since Bill has one unique ID that falls between the date range. I tried adding the...

Hi guys, I'm trying to write a formula which counts 5 days (inc weekends) from today UNLESS today falls on a weekend - then I need it to tell me the date 5 days from the next working day. Is that possible? Cheers in advance, JP

I have a column (call it A) with different times entered into it, it is formatted as HH:MM and can be anytime of the day. I am trying to identify a formula that will place a yes in the corresponding cell in column B if the time falls between the hours of 01:00 and 07:00. I have tried all sorts...

I am trying to find an equation that looks at my data, lets say column A, and if it falls between 1-10 then subtract by 10, but if the same column falls between 11-19 then subtract by 5, and so for. Please help, I have read various examples and watched various videos but still can not figure...

Hello. This is my first post on the forum. I am attempting to create a formula where a cell will populate with a certain number when an adjacent cell is between two numbers. In plain language B2 will fill with "1" when C2's data falls between 0 and 14. I have four additional number ranges: B2...

I'm using this formula to count the number of instances when a time value falls between 00:00 and 06:00; The range B2:B998 is formatted as Custom hh:mm but the formula result is giving me zero, which is not correct. Can anyone spot where I am going wrong please?

If I have a list of names in column A and various dates in columns B through E, can I create a formula that pulls names from A if it falls withing a date range of those listed between B and E? Thanks in advance!

Looking to find a formula that will help me find the exact amount of time that falls within a given range. Here is my situation: I have been tasked to find the amount of time that falls within an "Operational time". The range of this operational time is between 06:00:00 and 22:00:00. Here is an...

Hi Guys, Hope you can help. I need to compare dates between two columns and return various types of text string. We have an assessment date which can vary and is always based on the first day of the month in a year. This needs to be compared to an earnings period date and the two dates will...

Hey there i know there is something simple I am missing. I am trying to set up a formula that will pull data from a cell based on where another cell falls in line numerically A B C 1 <2999 <9999 <250000 2 10 20...

Simple Code does not work If Range("B7") = "1" Then End If When there is a 1 in cell B7 the code falls through and executes the remaining code whereas it should stop immediately.

I am having an issue extracting data from a column that I have. I need the city of the customer in a new column. The column that I already have is as so: <tbody> US315310 - SENSICAL SOLON OH <tbody> US318310 - DKM-AD ART BUFFALO NY </tbody> </tbody> US500190 - STANDARD RUBBER...