| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching numbers witin a series
A3 and A4 contain from and to dates.
B1 and B2 contain Year one start & Finish (eg 1/1/05 and 31/12/05) Subsequent Colums contain subsequent years. I need help in trying to establish how many days within the dates specified in A3 and A4 are also contained within the periods specified in each column. I am using Microsoft Office XP. -- Ron. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Matching numbers witin a series
Hi!
If I understand correctly: =SUMPRODUCT(--(ROW(INDIRECT(B1&":"&B2))=$A3),--(ROW(INDIRECT(B1&":"&B2))<=$A4)) Copy across as needed. Biff "Bismark" wrote in message ... A3 and A4 contain from and to dates. B1 and B2 contain Year one start & Finish (eg 1/1/05 and 31/12/05) Subsequent Colums contain subsequent years. I need help in trying to establish how many days within the dates specified in A3 and A4 are also contained within the periods specified in each column. I am using Microsoft Office XP. -- Ron. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Matching numbers witin a series
Thanks Biff.
Your response was exactly what I needed. I don't understand it, but it does exactly what I want. Many thanks. -- Ron. "Bismark" wrote: A3 and A4 contain from and to dates. B1 and B2 contain Year one start & Finish (eg 1/1/05 and 31/12/05) Subsequent Colums contain subsequent years. I need help in trying to establish how many days within the dates specified in A3 and A4 are also contained within the periods specified in each column. I am using Microsoft Office XP. -- Ron. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Matching numbers witin a series
You're welcome. Thanks for the feedback!
Biff "Bismark" wrote in message ... Thanks Biff. Your response was exactly what I needed. I don't understand it, but it does exactly what I want. Many thanks. -- Ron. "Bismark" wrote: A3 and A4 contain from and to dates. B1 and B2 contain Year one start & Finish (eg 1/1/05 and 31/12/05) Subsequent Colums contain subsequent years. I need help in trying to establish how many days within the dates specified in A3 and A4 are also contained within the periods specified in each column. I am using Microsoft Office XP. -- Ron. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Matching numbers witin a series
=MIN($B$2,$A$4)-MAX($B$1,$A$3)+1
Regards, Bernd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add (') at the beginning and end of a series of numbers? | Excel Discussion (Misc queries) | |||
| Trying to change ColorIndex for series settings | Charts and Charting in Excel | |||
| Extract sub-string of number from field of long series of numbers | Excel Worksheet Functions | |||
| How to change a series of positive numbers to negative numbers | Excel Worksheet Functions | |||
| Matching parts to model numbers | Excel Discussion (Misc queries) | |||
Linear Mode
