I have the following three columns, No Weeks= 6, Start Date = 31/3/6 End
Date =12/5/6 . I need a formula to calculate a revised date such that if
the End Date is between 3/4/6 and 16/4/6 then I need 14 days added to it.
All other dates to remain unaffected.

Does anyone know a formula to do this.

Thanks