between dates

Hi everyone, Please see below sample data set. The columns are always going to be the same, but the rows will be dynamic each time a report is run. ABCDEFG1Start01-May2End07-May34NoNameDateCategoryTypeDrCr515Name101-MayEntertainment-200690Name201-MaySupplies1500745Name301-MayTravel...

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

Hi community- I'm looking for a formula to sum up working hours for various employees , grouped by Optician ID, if they had an active contract within a certain month. I've played around with SUMIFS, but I get an error message, that it's not a formula...

Hello All. Please help. I am trying to create a worksheet on an iPhone. With MUCH difficulty. I am a lorry driver and what I need is this... I enter the last date and time I finish work in the appropriate cells of week "1". And I add the date and time I start work the following week after my...

I need a formula to find which months have more weeks than others. I get paid every fourth Wednesday. Some months, sometimes 4 or 5, I have to wait 5 weeks between paydays, most other months I wait 4 weeks between paydays. Need a formula to tell me which months has 5 weeks between every 4th...

Hi guys, I am producing a milestone view based on a variety of columns containing dates and this then plots out milestones based on the results...

Hi, I would appreciate any help creating a macro to hide columns for a range of cells based on todays date minus 3 years. I currently have about 20 columns. Each column heading is a persons name. Each column under the persons name has 10 rows of dates. To send out a monthly report of people that...

Hello all, I'll get right to the point... I have 2 sheets Sheet1 <tbody> A B C 1 Bill Murry 05/14/2007 WI 2 Bill Murry 02/20/2008 TX 3 Bill Murry 11/12/2008 NY </tbody> On my second sheet I have <tbody> A B C D 1 Bill Murry 03/02/2007 08/04/2007 **Formula** = WI 2 Bill Murry...

Hello, I'm having trouble with this and I'm hoping somebody here may be able to help. Here is a sample of my data: <tbody> 2011 2011 2011 2011 2012 2012 2012 2012 2013 2013 2013 2013 2014 2014 2014 2014 <tbody> Co.1 </tbody> <tbody> Co.1 </tbody> <tbody> Co.2...

I'm sure there is probably an easy way to do this, but I can't wrap my head around it. Say the beginning date in E4 = 2/2/14, the ending date in F4 = 4/5/14. I have columns headings listing the beginning and ending dates of each month, where L1 = 1/1/14 and L2 = 1/31/14, M1 = 2/1/14 etc. I...

I have a matrix of date ranges with a value on sheet 1, like this:</SPAN></SPAN> <TBODY> A</SPAN></SPAN> B</SPAN></SPAN> C</SPAN></SPAN> 1/1/2014</SPAN></SPAN> 7/1/2014</SPAN></SPAN> 3.625</SPAN></SPAN> 7/1/2013</SPAN></SPAN> 1/1/2014</SPAN></SPAN> 1.75</SPAN></SPAN>...

Hi guys, What I need is a formula that recognises 2 dates and counting how many of them there are. E.g. On the example below, on the "dates received" column they are all in march, so I need a formula which counts all the dates between 01/03/2014 and 31/03/2014. TIA <colgroup><col><col...

I have a dynamic database, filled everyday with data in some columns. I enter, in column C a Date and in column G a number. Other columns contain strings. What I want is to get the SUM of dynamically filled column G numbers, for these cases: 1) From the beginning of the current year (January...

Looking for a formula in excel, was thinking of an IF with AND or VLOOKUP?? I have a database in Excel that has A B C 1 9/1/98 8/31/00 RED 2 9/1/00 8/31/02 BLUE 3 9/1/02 8/31/04 GREEN 4 9/1/04 8/31/06 YELLOW What formula would I use to take a Date (lets say its...

So I have two sets of data that I need to match up. Set 1: Column A has "Vehicles" like 29, 21, 20, etc. Column B has "Date/time" of when that vehicle last sent data. Set 2: Column D has the "Arrival Date/Time" of when the vehicle entered a location. Column E has the "Departure Date/Time" of...

Hey guys, seen as you were so efficient last time, was wondering if you might be able to help me once more. Taking this down to brass tacks as it were, I have a table with two date columns, and I want excel to highlight all the dates in the same row that are between these values. e.g So...

Using Excel 2010. I can make Conditional Formatting work great between dates that DO span a whole year. But try to split a year into two and it won’t work. My fiscal year (FY) starts October 1 and ends September 30 of the next year. I want to be able to enter a date for any FY and have the cell...

I have been using CountIfs with a lot of luck until I added one extra criteria that it ignores. Can anyone tell me why? ORIGINAL FORMULA =COUNTIFS(ADate, ">" & N$2, ADate, "<" & O$2, WBid, ">=" & 10000, WBid, "<30000") NEW FORMULA =COUNTIFS(ADate, ">" & N$2, ADate, "<" & O$2, WBid, ">=" &...

Hey everyone . . . Got a question about a few formulas I am trying to work through. I am attempting, unsuccessfully, to create a formula that will first look at a range and make sure the selected dates are within range and then count the occurrences of a cells value that matches within a range...

-------a---------|------ b--------|-----c-----|-----d----| 1----------------|----------------| $500.00---| $299.00--| 2----------------|----------------|----22-----|-----7----| 3 Fri Dec-09-11 | Thu Dec-22-11 | 4 Fri Dec-23-11 | Thu Jan-05-12 | 5 Fri Jan-06-1 | Thu Jan-19-12 |...