date criteria

  1. G

    Prioritizing Tasks based on two Date Criteria

    Hello, I need some help in creating a formula or a macro that will prioritize (and assign a number to) a list of tasks based on two dates. The data is applications received, we have two dates, one is the date the application was received, and the other is the requested date of retirement. I...
  2. T

    if function - logical test = date range ?

    I would like a certain value to appear if the date in a particular column falls within a time period. What would a formula for that look like? - Ted
  3. B

    Advanced Filter with Date Criterion Range

    I"m trying to create a criteria range for an Excel advanced filter that uses a date combined with an > = operator. is there a way to use a >= operator in front of the formula that derives the date?
  4. A

    UDF. If "not a date" set output to "0"

    Hi guys, Just a small one I can't get right. Public Function OtHours(Workday As Date, Hours As Single) Dim DayNumber As Integer DayNumber = Weekday(Workday, vbSunday) If Hours = 0 Then OtHours = 0 If Workday = 0 Then OtHours = 0 If DayNumber = 1 Then OtHours = Hours * 2 Else...
  5. A

    Sumif on match AND date criteria?

    I need to sum values in a column if both serial numbers match AND if the match's date is less than 5 days ago. I can do both individually: =SUMIF('All2'!$AH$3:$AH$1000,F4,'All2'!$AI$3:$AI$1000) =SUMIF('All2'!$AJ$3:$AJ$1095,"<="&NOW()-5,'All2'!$AI$3:$AI$1095) But I can't for the life of me...
  6. B

    Countif with Date Criteria

    Is there a way to count cells if the date populated is equal to or less than a defined date? if so, can somone provide the syntax? Thanks! blue rhino

This Week's Hot Topics

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
Top