Date Ranges - Simplified??

[missmeliss]

Hi All,

I have a good one...
I have a data table with all sorts of dates. I am importing goods on different dates. How do I write a formula that will pull the # if units I am importing based on a week ending date?

 

[ukmikeb]

Hi

Perhaps you could adapt the solution offered in this thread -

http://www.mrexcel.com/forum/showthread.php?t=551359&highlight=sumproduct+dates

to suit your needs.

hth