Hi,
i have a begin date and end date and i want to know how many days falls in week 20 without the weekend.
please see attachment
kind regards
framboosje
Hi,
i have a begin date and end date and i want to know how many days falls in week 20 without the weekend.
please see attachment
kind regards
framboosje
Last edited by Framboosje; 05-31-2018 at 07:39 AM.
Try this in F3:
=SUMPRODUCT(--(WEEKNUM(ROW(INDIRECT($C$3&":"&$D$3)))=F$2))
Last edited by Phuocam; 05-31-2018 at 07:44 AM.
Expanding on Phuocam's suggestion, try
=SUMPRODUCT(--(WEEKNUM(ROW(INDIRECT($C$3&":"&$D$3)),21)=F$2),--(WEEKDAY(ROW(INDIRECT($C$3&":"&$D$3)),2)<6))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks