Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting the value of the Minimum Date
Hey there,
Got this problem, I have a table setup as Week of month Date Date Month week1 01/08/2006 Aug-06 week1 02/08/2006 Aug-06 week1 03/08/2006 Aug-06 week1 04/08/2006 Aug-06 week2 07/08/2006 Aug-06 week2 08/08/2006 Aug-06 week2 09/08/2006 Aug-06 week2 10/08/2006 Aug-06 week2 11/08/2006 Aug-06 week3 14/08/2006 Aug-06 week3 15/08/2006 Aug-06 week3 16/08/2006 Aug-06 week3 17/08/2006 Aug-06 I am trying to get a function that will use a list formatted as above and give me the beginning date and ending date for each week of a particular month. Using the sample table above, the function must be such that if I input week1 and Aug-06 it would automatically generate the values 01/08/06 and 04//08/06. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting the value of the Minimum Date
=MIN(IF((A2:A20="week1")*(C2:C20="06-Aug"),B2:B20))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. ans similarly for MAX -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Kurt" wrote in message ... Hey there, Got this problem, I have a table setup as Week of month Date Date Month week1 01/08/2006 Aug-06 week1 02/08/2006 Aug-06 week1 03/08/2006 Aug-06 week1 04/08/2006 Aug-06 week2 07/08/2006 Aug-06 week2 08/08/2006 Aug-06 week2 09/08/2006 Aug-06 week2 10/08/2006 Aug-06 week2 11/08/2006 Aug-06 week3 14/08/2006 Aug-06 week3 15/08/2006 Aug-06 week3 16/08/2006 Aug-06 week3 17/08/2006 Aug-06 I am trying to get a function that will use a list formatted as above and give me the beginning date and ending date for each week of a particular month. Using the sample table above, the function must be such that if I input week1 and Aug-06 it would automatically generate the values 01/08/06 and 04//08/06. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting the value of the Minimum Date
Thanks Bob,
But the formula did not work. I was wondering if I cant use a DMIN function. Please advise. Kurt "Bob Phillips" wrote: =MIN(IF((A2:A20="week1")*(C2:C20="06-Aug"),B2:B20)) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. ans similarly for MAX -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Kurt" wrote in message ... Hey there, Got this problem, I have a table setup as Week of month Date Date Month week1 01/08/2006 Aug-06 week1 02/08/2006 Aug-06 week1 03/08/2006 Aug-06 week1 04/08/2006 Aug-06 week2 07/08/2006 Aug-06 week2 08/08/2006 Aug-06 week2 09/08/2006 Aug-06 week2 10/08/2006 Aug-06 week2 11/08/2006 Aug-06 week3 14/08/2006 Aug-06 week3 15/08/2006 Aug-06 week3 16/08/2006 Aug-06 week3 17/08/2006 Aug-06 I am trying to get a function that will use a list formatted as above and give me the beginning date and ending date for each week of a particular month. Using the sample table above, the function must be such that if I input week1 and Aug-06 it would automatically generate the values 01/08/06 and 04//08/06. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting the value of the Minimum Date
Did you array enter it as I suggested?
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Kurt" wrote in message ... Thanks Bob, But the formula did not work. I was wondering if I cant use a DMIN function. Please advise. Kurt "Bob Phillips" wrote: =MIN(IF((A2:A20="week1")*(C2:C20="06-Aug"),B2:B20)) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. ans similarly for MAX -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Kurt" wrote in message ... Hey there, Got this problem, I have a table setup as Week of month Date Date Month week1 01/08/2006 Aug-06 week1 02/08/2006 Aug-06 week1 03/08/2006 Aug-06 week1 04/08/2006 Aug-06 week2 07/08/2006 Aug-06 week2 08/08/2006 Aug-06 week2 09/08/2006 Aug-06 week2 10/08/2006 Aug-06 week2 11/08/2006 Aug-06 week3 14/08/2006 Aug-06 week3 15/08/2006 Aug-06 week3 16/08/2006 Aug-06 week3 17/08/2006 Aug-06 I am trying to get a function that will use a list formatted as above and give me the beginning date and ending date for each week of a particular month. Using the sample table above, the function must be such that if I input week1 and Aug-06 it would automatically generate the values 01/08/06 and 04//08/06. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
Date format issue | New Users to Excel | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Minimum Date Range from other cells | Excel Worksheet Functions | |||
Another Date issue. | Excel Worksheet Functions |