-
1. Re: Create Month/Day Filter for multiple years on one sheet
Deepak Rai Dec 11, 2017 6:57 AM (in response to brandon.lum)yes that can be done. Please attach a sample workbook and your requirement.
Thanks
Deepak
-
2. Re: Create Month/Day Filter for multiple years on one sheet
Jim DehnerDec 11, 2017 7:49 AM (in response to brandon.lum)
Hi Brandon
See the attached
the formula below will set the date range - year to date for each year based on the parameter
And will return this
I just put in a table calc for YOY to show how it works
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
-
this year last year.twbx 1.2 MB
-
-
3. Re: Create Month/Day Filter for multiple years on one sheet
brandon.lum Dec 12, 2017 4:42 AM (in response to Jim Dehner)Thanks Jim!
This was definitely helpful. Unfortunately, this does not take into account my calendar parameters or my other filtered criteria (which wasn't in the initial scope). Do you know if there is an easy solution to adjusting this to a specific fiscal year cycle? I've already adjusted my original date source to my FY start, thought that may compensate, but it doesn't seem like it.