Tuesday, February 5, 2013

yogi_Pull Selected Field Entries For A Date Before The Specified Date

                                          Google Spreadsheet   Post  #1013
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 05, 2013
post by user: alexander stanton said:(http://productforums.google.com/forum/?zx=pk24ifk32f07#!category-topic/docs/spreadsheets/UUUqTl9-Gtw)
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.

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
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'
following is a solution to a bit more generalized problem