this is a link to the spreadsheet
https://docs.google.com/spreadsheets...it?usp=sharing
this is the IFerror statement I am currently using
=iferror(filter(TASKS!$B$2:$B$1001,TASKS!$A$2:$A$1001=B$1,TASKS!$C$2:$C$1001=$A5))
I want to pull ONLY the tasks that fall within the date range of 5/13/2014 - 5/18/2014 from the 'TASKS' sheet...is this possible?
thank you in advance for all your help and forgive me if this is a silly question as I am a noob
Brian
Bookmarks