Formula Required
Philip
I entered the formula exactly as you stated but the calculation does not add
on the extra 14 days. If I write L32/4/6 will it recognise it as a date or
does it have to be in inverted commas?
"Philip J Smith" wrote:
Try putting this in a new column Revised End Date
=IF(AND(EndDateHoliday_Start,EndDateHoliday_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
"Funkyfido" wrote:
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
|