software

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

Try putting this in a new column Revised End Date

=IF(AND(EndDategt;Holiday_Start,EndDatelt;Holiday_End) ,EndDate 14,EndDate)

Regards
Phil

Whe

EndDate is the date to be tested
Holiday_Start is 03/04/06
Holiday_End is 16/04/06

quot;Funkyfidoquot; wrote:

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

Philip

I entered the formula exactly as you stated but the calculation does not add
on the extra 14 days. If I write L3gt;2/4/6 will it recognise it as a date or
does it have to be in inverted commas?

quot;Philip J Smithquot; wrote:

gt; Try putting this in a new column Revised End Date
gt;
gt; =IF(AND(EndDategt;Holiday_Start,EndDatelt;Holiday_End) ,EndDate 14,EndDate)
gt;
gt; Regards
gt; Phil
gt;
gt; Whe
gt;
gt; EndDate is the date to be tested
gt; Holiday_Start is 03/04/06
gt; Holiday_End is 16/04/06
gt;
gt; quot;Funkyfidoquot; wrote:
gt;
gt; gt; I have the following three columns, No Weeks= 6, Start Date = 31/3/6 End
gt; gt; Date =12/5/6 . I need a formula to calculate a revised date such that if
gt; gt; the End Date is between 3/4/6 and 16/4/6 then I need 14 days added to it.
gt; gt; All other dates to remain unaffected.
gt; gt;
gt; gt; Does anyone know a formula to do this.
gt; gt;
gt; gt; Thanks