Results 1 to 15 of 15

Count specific day between fixed dates, with user input controlling time frame, month/s

Threaded View

Joe Bob Crain Count specific day between... 02-01-2017, 05:40 PM
dflak Re: Count specific day... 02-02-2017, 02:41 PM
Joe Bob Crain Re: Count specific day... 02-03-2017, 06:08 PM
dflak Re: Count specific day... 02-03-2017, 06:20 PM
dflak Re: Count specific day... 02-03-2017, 06:13 PM
Joe Bob Crain Re: Count specific day... 02-06-2017, 09:19 AM
dflak Re: Count specific day... 02-06-2017, 11:59 AM
Joe Bob Crain Re: Count specific day... 02-06-2017, 12:39 PM
dflak Re: Count specific day... 02-06-2017, 01:23 PM
Joe Bob Crain Re: Count specific day... 02-07-2017, 12:20 PM
dflak Re: Count specific day... 02-07-2017, 01:55 PM
Joe Bob Crain Re: Count specific day... 02-09-2017, 06:11 PM
dflak Re: Count specific day... 02-09-2017, 06:21 PM
dflak Re: Count specific day... 02-10-2017, 10:01 AM
Joe Bob Crain Re: Count specific day... 02-12-2017, 04:16 PM
  1. #1
    Registered User
    Join Date
    03-24-2006
    Posts
    9

    Count specific day between fixed dates, with user input controlling time frame, month/s

    I would post a file but I cannot insert the excel file.

    Start Date End Date TOTAL DAYS END DATE MINUS START DATE SATURDAYS END DATE MINUS START DATE SAT in DATE RANGE SUNDAYS END DATE MINUS START DATE SUN in DATE RANGE WEEK DAYS ONLY WEEK DAYS IN DATE RANGE DATE RANGE (W14 and W15)"

    =IFERROR(SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(G31&":"&F31)))={1,2,3,4,5,6,7})),"0") =IFERROR(SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(G31&":"&F31)))=7)),"0") =IFERROR(SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(G31&":"&F31)))=1)),"0") =IFERROR(SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(G31&":"&F31)))={2,3,4,5,6})),"0") =IF(OR($G31<$W$14,$F31>$W$15),0,ABS(NETWORKDAYS(MIN($W$15,$G31),MAX($W$14,$F31)))) =IF(OR($G31<$W$14,$F31>$W$15),0,ABS(NETWORKDAYS(MIN($W$15,$G31),MAX($W$14,$F31)))) =IF(OR($G31<$W$14,$F31>$W$15),0,ABS(NETWORKDAYS(MIN($W$15,$G31),MAX($W$14,$F31)))) =IF(OR($G31<$W$14,$F31>$W$15),0,ABS(NETWORKDAYS(MIN($W$15,$G31),MAX($W$14,$F31))))

    I have trouble for the results for SAT in Date Range and Sun in Date Range

    Thank you, dflak

    I attached the xlsm file and when I try to open it is says it is a php file. I changed the extension from php to xlsm and it opens in exel.
    Attached Files Attached Files
    Last edited by Joe Bob Crain; 02-03-2017 at 05:24 PM. Reason: Adding Spread Sheet and file extension

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Number of Samples in a Month time frame
    By lchee in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-03-2016, 03:48 AM
  2. Replies: 2
    Last Post: 04-15-2015, 03:58 PM
  3. Replies: 2
    Last Post: 12-17-2013, 06:30 AM
  4. [SOLVED] Controlling dates that overlap from month to month
    By dontaylor in forum Excel General
    Replies: 2
    Last Post: 10-22-2013, 11:06 AM
  5. Excel 2007 Horizontal Bar Chart with fixed time frame
    By chartnovice in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-19-2012, 01:16 PM
  6. Loan Calculator with Terms based on Fixed Payment not a fixed time frame.
    By cc4digital in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-03-2012, 04:49 AM
  7. Count specific dates in cell range for current month
    By rboggio1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-22-2009, 10:21 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1