Create everyday report from a database for workdays of current month passed

[agios59]

In column A of a database I've calculated workdays for all year (excluding weekends and public holidays).
Every day, I update the numerical data of the database, with the facts of previous day.
In another sheet I've made some monthly, quarterly etc., reports for that data.
What I want, is to have:
1) a report every day, with the sum of specific data (say that in column D), for a period starting the first workday of current month and ending the previous workday of today.
2) the total workdays days for that period.
Thanks in advance

[protonLeah]

Welcome to the forum.
We only help on certain problems not to create a worksheet for you..
You should start first then if you encounter a problem on the worksheet it's the the time to ask a question to fellow members.
Thanks.

[agios59]

I'm afraid there's a misunderstanding about my needs. Maybe I wasn't so clear.
I only want a formula in a cell of a worksheet, that sums specific values located in another worksheet.
Of course, I would never asked to create the entire worksheet for me.

[Kevin UK]

Hi

Have a look at the SUMPRODUCT function, without seeing any data, something along these lines.

Dates in column A and values in column B. D1 = Start date & E1 = End Date

Please Login or Register  to view this content.

[agios59]

OK. Thanks