yogi_Pull Selected Field Entries For A Date (from DateTime column) Before The Specified Date

                                          Google Spreadsheet   Post  #1017

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 06, 2013
post by user: alexander stanton said:(http://productforums.google.com/forum/?zx=pk24ifk32f07#!category-topic/docs/spreadsheets/UUUqTl9-Gtw)

the solution in this post supplements the solution to the following problem

Finding Last Date before today
I'm Trying to come up with a formula to return the last date before today with an extra criteria.

https://docs.google.com/spreadsheet/ccc?key=0AofFwgs4dUiZdHF5d3VIQTVZYWI2ekZqTmJ5MmFNaFE&usp=sharing

this array has dates before and after today with different people, I'd like to be able to get the last date before today for frank

Thanks!

---

I'd like to also be able to look up the data in the third column for a certain person and date

---

Sorry for the confusion. What I mean is the last date before today for frank, and the contents of column c for that date.

So it should return 1/25 and 'did a funny dance'
Since today is 2/5
If today were 2/10 it would return 2/7 and 'n/a'
---
the following solution was prompted because Alex was having difficulty implementing the solution I had provided earlier to his real data  as he mentioned in the following 

I've tried it in test file after test file and it keeps working perfectly, but for the life of me I can't get it to work on the actual data. I've removed any private information, here is the actual file:

https://docs.google.com/spreadsheet/ccc?key=0AofFwgs4dUiZdGIwVjJfam95Z2h4S2dsZWtEOUdIU1E&usp=sharing

The data on the 'gears' page columns A-F comes in from google calendar using an app script. The formula is needed on the'Daily Reports' sheet.

Thanks for your help!!
Alex

--------------------------------------------------------------------------------------------

here we go ...