I've attached a test spreadsheet,
I'm basically trying to find a formula which can calculate not only the number of working days between 2 dates, but then add them up to sums within ranges.
It'll make more sense on the attached sheet; hope someone can help,
ThanksTest - Number of Dates within range.xlsxTest - Number of Dates within range.xlsx
see the attached file some modifications made to report table
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
At its most basic, using NETWORKDAYS will give you the working days between two dates.
therefore in C3
and drag down
Please Login or Register to view this content.
then in G3
and amend accordingly for the other counts......the last one "Respose Outstanding" will need to be:Please Login or Register to view this content.
Please Login or Register to view this content.
If someone has helped you then please add to their Reputation
If you want you can combine Siva's suggestion with pjwhitfield's, e.g. with Siva's setup you can use this formula In H3 copied to H6 to only account for working days
=SUMPRODUCT((NETWORKDAYS($A$3:$A$46+0,B$3:B$46+0)>=$E3)*(NETWORKDAYS($A$3:$A$46+0,B$3:B$46+0)<=$G3))
Note, NETWORKDAYS counts both start and end date, so Monday to Friday in the same week counts as 5, you may want that to be 4?
Audere est facere
Hi,
Does the attached, which uses a Pivot table help.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks