+ Reply to Thread
Results 1 to 4 of 4

Excel formula to find out what workday of a month is a particular date

  1. #1
    Registered User
    Join Date
    03-16-2016
    Location
    London
    MS-Off Ver
    Office 2021
    Posts
    67

    Excel formula to find out what workday of a month is a particular date

    Hi

    Appreciate some help to find out what work day a date in a particular month

    I have attached a sample excel , with the expected result in Coloumn D

    Thank you in advance
    Attached Files Attached Files

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: Excel formula to find out what workday of a month is a particular date

    how about
    =NETWORKDAYS.INTL(DATE(YEAR(C3),MONTH(C3),DAY(1)),C3,1,$I$3:$I$10)
    Attached Files Attached Files
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: Excel formula to find out what workday of a month is a particular date

    Another way:
    Please Login or Register  to view this content.
    Quang PT

  4. #4
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,435

    Re: Excel formula to find out what workday of a month is a particular date

    A third way:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to identify nth workday in a month (all weekends to be excluded)
    By tarun.tuli in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 09-30-2021, 09:41 AM
  2. [SOLVED] =workday formula to count from supplied date to current date
    By MattExcelLearner in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-07-2019, 06:52 AM
  3. [SOLVED] Macro to run if workday date is after the 7th of every month
    By jennis7242 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-23-2019, 04:41 PM
  4. Replies: 3
    Last Post: 01-03-2015, 03:33 PM
  5. [SOLVED] Formula to find the week and month from a date
    By arun.sj in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-01-2014, 05:11 AM
  6. Excel find earliest date within 12 month period.
    By rkemplin in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-18-2012, 09:13 PM
  7. Find First Workday of Month Value Excl Holiday
    By the.ronin in forum Excel General
    Replies: 8
    Last Post: 04-14-2011, 10:09 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