Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need a formula that will display which period a set of dates belongs to.
The info looks like this, located in a sheet named 'Period Dates'. Period Start End Period 1 01/04/2006 28/04/2006 Period 2 29/04/2006 26/05/2006 Period 3 27/05/2006 23/06/2006 Period 4 24/06/2006 21/07/2006 Period 5 22/07/2006 18/08/2006 Period 6 19/08/2006 15/09/2006 Period 7 16/09/2006 13/10/2006 Period 8 14/10/2006 10/11/2006 Period 9 11/11/2006 08/12/2006 Period 10 09/12/2006 05/01/2007 Period 11 06/01/2007 02/02/2007 Period 12 03/02/2007 02/03/2007 Period 13 03/03/2007 30/03/2007 In another sheet, I have column T called 'date in'. I need the formula to pick out this date, find it in the info above and return the corresponding period. However, it is proving difficult as the date is located between the 'start' and 'end' dates. I have tried IF(T4<='Period Dates'!C9,"5",IF(T4<='Period Dates'!C10,"Period 6"). I can only do up to 8 IF statements though, is there another option?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
Huge problem with "if" formula's | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |