# date criteria

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

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

### Which adblocker are you using?

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

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