That's working like a charm thanks so much! I'm still learning when it comes to this type of syntax so it's great you guys are so helpful!
I haven't answered your answer as correct yet because I stil have a couple of things similar I'm trying to solve.
What would the equation be to select the end of the previous FiscalYear, and the end of the previous Year (not fiscal)?
End of previous FiscalYear being Jun-14 and end of previous year being Dec-14 in this case.
I can't seem to work it out.