without looking at your file just use, where b1 has a desired date
=sumproduct((a2:a22=b1 etc
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sinner" wrote in message
...
Hi,

I have this sheet with almost all formulas of sumproduct. Calculations
based on start/end dates.
It takes quite some time calculating all the formulas.
Do expand the columns to see the sumproduct formulas.

Here I would like to have some macro to run after I mention dates and
calculate all the results.

Sample file is at http://www.savefile.com/files/1621169

Thx.