Results 1 to 6 of 6

network days formula not handling cases when start date is weekend

Threaded View

FireDept network days formula not... 04-29-2024, 06:16 AM
Kaper Re: network days formula not... 04-30-2024, 10:58 AM
kvsrinivasamurthy Re: network days formula not... 05-01-2024, 10:54 AM
Kaper Re: network days formula not... 05-02-2024, 05:32 AM
kvsrinivasamurthy Re: network days formula not... 05-03-2024, 02:01 AM
FireDept Re: network days formula not... 06-04-2024, 10:30 AM
  1. 04-29-2024, 06:16 AM #1
    FireDept is offline
    Registered User
    Join Date
    01-25-2022
    Location
    London, England
    MS-Off Ver
    Microsoft Office Professional Plus 2021; Office 365
    Posts
    85

    network days formula not handling cases when start date is weekend

    Hi Experts,

    I have a formula which calculates the working hours between two dates, considering a specific working schedule and excluding weekends and holidays.

    I have a problem regarding when the start date is in the weekend, example attached.

    Can someone please help?
    Attached Files Attached Files
    Alcohol & calculus don't mix.Never drink & derive.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Start Date + 8 Days but Can't End on a Weekend/Holiday
    By rebma in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-21-2021, 11:11 AM
  2. [SOLVED] Formula to count how many AM and PM sessions within a date range using Network Days
    By hodge1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-11-2016, 10:03 AM
  3. NETWORKDAYS with start date, end date, total days - if weekend subtract 1 from total
    By PConn31 in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 10-08-2014, 10:31 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. Excel Formula help - Network Days minus certain dates in the date range ......
    By Smiffy3594 in forum Excel General
    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. Excel running date formula minus weekend days
    By Eliane in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-30-2005, 06:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1