Hey All 
I love the InDateRange and InPriorDateRange functions. They make it so easy to create period comparison analysis.
I wanted to share a workbook I created to help me better understand what time periods the functions were returning and how to manipulate them to find any time frame I wanted.
Check it out: Try out Date Range Functions in Sigma
Let me know what you think!
-Katrina