date criteria

Hello All, I have tried to formulate something that searches through rows to meet 4 criterias. If all criteria is met I need the row number or the entire row returned, if not continue the search. Half of my criteria is straight forward BLUE=BLUE, GREEN=GREEN while the other two needs to be...

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

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

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?

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

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

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