Results 1 to 3 of 3

NETWORKDAYS for current week minus holidays no start date

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-12-2014
    Location
    Reading
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2403 Build 16.0.17425.20176) 64-bit
    Posts
    142

    NETWORKDAYS for current week minus holidays no start date

    Hi ,

    I have a spread sheet that works out daily gross profit for sales people in the office so I can see where there are on target for the current month and the current week.

    I'd like it to be able to tell me how many workdays there are in the current week without having so specify a start date.

    Is that possible?

    It is for the month (using EOMONTH) but I'm not sure about the week.

    I've attached what I have already. Cell B13 is where I need it.

    STWM.xls
    Last edited by blackburnsexcel; 08-24-2015 at 09:26 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 10
    Last Post: 02-29-2024, 08:55 AM
  2. [SOLVED] 3 days prior to today minus weekends and holidays
    By Thunderer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-17-2014, 09:54 PM
  3. Excel 2007 - Add on 7 days minus holidays
    By thekerrs in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-30-2012, 06:14 AM
  4. [SOLVED] Find date using start date and number of network days
    By v!ctor in forum Excel General
    Replies: 4
    Last Post: 07-06-2012, 05:27 PM
  5. Replies: 5
    Last Post: 12-15-2011, 11:16 AM
  6. aging formula with network days from start to today
    By eddienole in forum Excel General
    Replies: 2
    Last Post: 08-30-2011, 10:43 AM
  7. Replies: 5
    Last Post: 08-02-2011, 07:11 AM
  8. Start Date minus (Years + Months + Days) = ?
    By quartz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-11-2006, 01:10 PM

Tags for this Thread

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