date and range

  1. D

    Cell Formatting Based on Current Date

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

    Need help finding averages between a range of dates.

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

    Date formula

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

    VBA help needed please - splitting date range into monthly values!

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

    Require date format - Tried to combine some code but can't get to work

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

    Dates in one column (K) £cost in another column (M) - How do I get cell Q1 to display all values up to a certain date (20th of the month)

    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!!! :)
  7. C

    Find Date in rows was contain Text "1"

    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"...
  8. S

    Anniversary date in a series of start and end dates

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

    create a custom date range based on user efficiency

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

    VBA date related copy and paste - same workbook

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

    Need Assistance with multi-condition "IF" formula

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

    Index Match on an exact Number and a Date within a Range

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

    Need help with IF statement calculating Dates

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

    Creating calendar view from list of data

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

    Calculate Tenure of an employee in the orgnanisation

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

    SUMPRODUCT data within a certain date range

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

    Formula Needed for Counting Users within a Specific Date Range

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

    find the last date of dates in order

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

    Three Date Related Criteria for Column Filter

    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?
  20. K

    Filter Data based on two cells

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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top