Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    London, Middlesex, England
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    NETWORKDAYS Function.. (2003)

    Hello,

    I'm trying to calculate the number of holidays in 2004 using the excel function.

    Please can you help me with this? (file is attached)

    Thanks super-loungers!

    BD.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: NETWORKDAYS Function.. (2003)

    NetWorkdays, does not calculate the number of holidays. It counts the number of days between date 1 and date 2 ignoring weekdays and any days within your Holiday list.

    If you want to know how many holidays in your holidayList are in 2004 then you can use the formula:
    <pre>=COUNTIF(HolidayList, ">="& DATE(2004,1,1))-COUNTIF(HolidayList, ">="& DATE(2005,1,1))</pre>


    Where "HolidayList" is a named range containing that dates of the holidays.

    Steve

Posting Permissions

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