I am wondering if there is a way to make the following an excel formula:

I am doing audits in various periods (monthly, quarterly, etc). The audit may or may not be completed on the scheduled date. However, I would like to have a "next audit" to be the first day of the following quarter. For example, if I have a quarterly audit that is completed on 2/14/05, my next audit should be 4/1 and not 5/14.

Is there a way of calculating this for the enter year based on the period?

Thanks.
Bruce