I am not sure if this is possible, but I have created a spreadsheet with numerous sheets upon it, with the first sheet acting as a landing page which draws information from the other sheets.
My question is I want the landing page to display information drawn from one sheet based on the date. The spreadsheet the information draws from has the following column headers, columns A is date, B is Name, and C is amount.
On the landing page I would like it to display the rows of text if they within 30 days of todays date.
I hope that makes sense, and many thanks in anticipation of your help,
Cheers,
Mark
