Can you explain this in some more detail?

You say you want to "formulate" the data in C19:C24 and D19:D24 based on the
information in A1:D4 - what exactly is it you want to do with C19:C24/D19:D24
and how do you use the information in A-D:1-4 to determine what to do with it?

Perhaps even give us a couple of expected results.

"Jeremy" wrote:

I am looking for a way to formulate the data in C19-24 as well as D19-24
using the information in A,B,C and D 1-4. Please note it is counting the
data including the months given and the months between. Can someone please
help with a
formula.

Thank you


A B C D
1 JAN JUNE 2 4
2 MAR JUNE 1 16
3 MAR MAR 2 2
4 FEB MAR 3 4

A B C D
19 JAN 2 4
20 FEB 5 8
21 MAR 8 26
22 APRIL 3 20
23 MAY 3 20
24 JUNE 3 20