date and range

Hey everyone, I have a group of cells in my workbook that I would like to change colors after a certain date. If today's date falls after the contents of cell AJ1 (which contains a reference date like 9/5/2019) then I want cells AG1:AJ77 to change to black with white font. In other words...

I'm fairly new to the more complex Excel formulas and need help finding the average number of days between a range of dates. I'm using Excel 365. I have 2 ranges of dates; one for a ship date and one for a received date. There are ~1000 lines of shipped dates, but not as many received since...

Hi I need some help writing a formula. I have a table showing dates of birth for employees. I want to be able to show a "yes" in the table if the employee reaches the minimum age in months under each of the years. So for example, the first employee with a dob of 1/2/1960 should only have Yes...

Hey guys, First post here so please forgive me if I miss anything.. I am new to VBA and attempting to find some coding that will allow me to allocate the below section units between months based on course start and end dates. I have entered a couple of lines below of what I'm working with. It...

Hi, I appreciate all the help. Here, I tried to enter the isdate function but can't seem to get it to work. So I took out and need help on how to have a line of code that requires this user to enter date format if the cell is empty. It works to say cell already has data but not to require date...

Hi, I am not even sure how to search this. I can find COUNTIF statements but they re only good to tell me how many days fall between before the 20th. Sorry if this is a dimwit question! Thanks in advance!!! :)

Dear all Master.... Example : <tbody> A B C D F G H I J Items 7/6/2018 7/7/2018 7/8/2018 7/9/2018 7/10/2018 7/11/2018 7/12/2018 Result Bananas 1 1 1 ? Apple 1 1 1 ? Orange 1 1 1 ? </tbody> I really need help, i want to find a Date in result column when found first "1"...

Hi folks, I am not sure how to Excel this problem. I have a series of start and end dates throughout the year, and over other years. For example: Start End Start End 2018-01-01 2018-04-01 2018-08-01 2018-12-01 I am trying to...

Hi guys. I am in search of some ideas. My spreadsheet works fine as it is, so i am in continuous improvement mode with it. I am a teacher who gives students date ranges to finish projects. An example would be assignment 1 started on 2-14-2018 and not due until 3-10-2018; the next project...

Hi All I am trying to transfer data from sheet 1 "report" in cells I11:V11 (fixed) and the date for this report is located in K1 to the corresponding date on sheet "Daily Data Input" to cells C:P (rows constantly change) where the dates are located in B:B (the entire year is listed here). The...

This is the first time I have been unable to find the answer to a formula question on these boards before, so I figured I would finally post a question myself: First, some background - I work with multiple clients, who each submit cases to me. My boss recently asked me to begin tracking whether...

Hey everyone, I'm trying to perform data analysis and need to pull in a contract number based on an ID field and determine which record to pull for that ID based on where the Prod Date falls within the From/To Date Ranges (which are each a different column). My data has a unique record per ID...

Hello there, I have a cell that marks an action item as priority 1, 2, or 3 depending in criticality of the item. I'd like to change this from a manual entry and have it look at Column J (which is the due date column) and change the priroity of the number depending on the due date. If it's...

Hi – I hope you can help, this is proving beyond me… I have two tables. The first contains the data, in this case a list of activities carried out in a personal fitness log and the date of each: <tbody> Date Activity 01/08/2016 <tbody> Running </tbody> 01/08/2016 Cycling 02/08/2016...

Hi, I need to calculate the tenure of employees in my org, i wrote this code however I keep getting an #value error, can someone help me? =DATEDIF(C2,TODAY(),"y") & " years, " & DATEDIF(C2,TODAY(),"ym") & " months " C2 is the cell where I have the employees joining date.

<tbody> A B C D E F G I J 1 5 2017 Data 2 Month Customer name Channel Gross sales Return 3 Current Month May-17 ABC BOOKSTORE BOOKSTORE 8,035 (788) 4 Channel Gross sales Return May-17 VENICE RUNNER SCHOOL RUNNER 36,103 (37,861) 5 BOOKSTORE 50,143 (788) May-17 PGSM...

Hi I have the following data and need to get a count of how many times a user has attended the lab within a specific date range. Can someone help me out with this please? As an example, how can I get the count of 3 if I select the date range of 4/3/2017 to 4/8/2017. I will have the user input...

Dears, i asking for something may be crazy but it would be highly appreciated if you can help me i have a lot dates in column (A) and i need to find the last date of each date range (dates in order) and put this date in column (B) next to the first date in range like the below example is...

Hi all, I'm trying to set the filter for a table column to shows cells with a date value between 7/1/14 and 6/30/15, OR that has no date value entered. I've done a fair bit of googling and poking around with Advanced Filters, but nothing has worked thus far. Can anyone help with this?

Hello: I have a report that is being dumped into excel. From that data, I have a Index Formula that is returning data based on client. When that data returns I need to be able to filter by date. I need to be able to type the date range in two separate cells. <tbody>...