+ Reply to Thread
Results 1 to 3 of 3

PART 2 - A formula to look at cell containing a date and return number of network day

  1. #1
    Registered User
    Join Date
    02-20-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    22

    PART 2 - A formula to look at cell containing a date and return number of network day

    Hi again,

    No sonner do I sort one problem, i'm hit again with another.......

    I have now been given the formula to help me with looking at a cell that contains a date [i.e. 06/02/2012] and returning the number of days in that month. [29]

    Is there a forumla whereby in cell A1 if have the same date 06/02/2012 the formula this time in cell A3 returns the number of weekdays only in that given month [Mon-Fri], so the answer would be 21 for Feb-2012.

    Sorry if these are basic questions.

    Many Thanks
    PW

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: PART 2 - A formula to look at cell containing a date and return number of network

    Perhaps =NETWORKDAYS(EOMONTH(A1,-1)+1,EOMONTH(A1,0))

  3. #3
    Registered User
    Join Date
    02-20-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: PART 2 - A formula to look at cell containing a date and return number of network

    Thank you, that works great.

    I now need to start understanding how these formulas are arrived at...... rather than just coping & pasting into my sheet.

    Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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