the Previous formula does not work
Is this what you meant for?
If you have the model calendar, you can use 'Previous' formula (as Mr. @nathan_rudman said) and avoid circular reference.
In original topic, it seems not to use the model calendar, and it is difficult to avoid circular reference, probably.
(Sorry, if I've misunderstood your question.)