Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Required
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Required
Try putting this in a new column Revised End Date
=IF(AND(EndDateHoliday_Start,EndDate<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 "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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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,EndDate<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 "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Nesting questions | Excel Worksheet Functions | |||
A Formula required - please! | Excel Discussion (Misc queries) | |||
Formula assistance required!!! | Excel Discussion (Misc queries) | |||
addition to my date formula...required | Excel Worksheet Functions | |||
Rate of return required formula | Excel Worksheet Functions |