Monday, May 27, 2013

yogi_Pull From Sheet1 Records That Are Within The Date Range Of Today And Next 28 Days

                                          Google Spreadsheet   Post  #1212
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May 27, 2013
user Alistair Fraser (http://productforums.google.com/forum/?zx=twarxl97ddra#!mydiscussions/docs/e12jwAERI4o)
How to set up a sheet to display selected rows from another sheet?
We would like to set up a sheet to display a list of rows from another sheet, which contain dates within the range: from today for the next 28 days.  These dates are in one of the columns of the source sheet.  The display sheet will look the same are the source sheet but just show the rows within the date range.
---
Thanks Yogi

I've tried to work it out, I think it's a QUERY, but not sure ...

Here a link to a sheet I've done to explain what I'm trying to do


Best Wishes

Alistair
------------------------------------------------------------------------------------------------------

No comments:

Post a Comment