Hypothetical situation; an employer must sign a document either prior to the end of a fiscal year or prior to the commencement of the fiscal year. The document's signature must occur prior to the end of the fiscal year for which it stands effective, or prior to the beginning of the fiscal year in which it turns effective. So, an employer, for the fiscal year flowing from 10/1/2014 to 9/30/2015, would have to sign a document effective 10/1/2014 on 9/30/2015 or earlier.

Can anyone think of an excel function to accommodate such a situation? I contemplate setting up a formula to determine the latest date on which one could sign a document based on its effective date.