If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
Formula Required
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel formula required | sportstar555 | General Discussions | 6 | April 1st, 2005 10:13 PM |
unable to repair inobox | Sudheer Mumbai | General Discussion | 1 | February 20th, 2005 11:55 AM |
Formula Help required | jagdishjoshi01 | General Discussion | 2 | September 23rd, 2004 02:43 PM |
Help required with Formula | Rashid Khan | Worksheet Functions | 2 | April 17th, 2004 08:14 PM |
Urgent help required - Excel Formula | Glenn | Worksheet Functions | 2 | November 23rd, 2003 03:01 PM |