date range formula

  1. E

    Average a range between 2 dates

    Hi Forum, Hope you can help. I have a worksheet updating every Monday with result from the previous week using VBA and appends to the right of the last entry. When a month is complete I am then required to report the average of the data points - each day has 24 data points for each hour so...
  2. L

    Help! Trying to pull historical employee data based on a date range.

    I have one file (Pay Statement) with Employee numbers (column B) and pay period dates (column E). In column M I am trying to pull in data from another file (History). The History file has the employee number (column A), the effective begin date (column C), effective end date (column D) and the...
  3. H

    Date Lookup Return row

    I am in need of vb code that takes date imputed into cell and returns the row number associated with date range. example below Enter Date of 2/14/2019 and code would return Row number as 3 ( for 2/1/2019 thru 2/28/2019 ) <tbody> Start Date End Date Enter Date: 2/14/2019 1/1/2019...
  4. V

    assistance using =SumProduct with a date range criteria

    Hey Guys! I'm currently using Sum Product to add up items on a table with a few criteria. For now it is summing '<=Today()' =SUMPRODUCT(--(TRANSACTIONS_ALL[date]<=TODAY()),--(TRANSACTIONS_ALL[TYPE]="PENDING CHECK"),TRANSACTIONS_ALL[AMOUT DUE]) Please assist so that instead of '<=Today()'...
  5. R

    Formula referencing time ranges

    I need to create a formula influenced by arrival and departure times. Each individual will come and go at their allotted times. We are working within windows of time. For example, people coming between 8 a.m. and noon and departing between 11 a.m. and 3 p.m. will be on a specific schedule...
  6. J

    Conditional formatting to highlight multiple date ranges in column calculating from today

    I have a column in excel of multiple dates and some blanks, I need to highlight the cells different colors based on their date range calculating from Today. Example, cells with no date a certain color, cells older than 1 day but less than 6 months a certain color, cells older than 6 months but...
  7. S

    SUMIFS - Date Range w/ Formula Driven Date

    Hi, decided I've spent enough time fumbling with this, time to ask for help. The RED section or 'criteria range 2' of this sumifs formula is what I need some help on. Column H = Duration in weeks, $H$6:$H$104 Column F = Start Date Range, $F$6:$F$104 Hypothetical 'End Date' column would equal...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top