+ Reply to Thread
Results 1 to 10 of 10

Working days passed & left in the month / week

  1. 01-09-2015, 08:29 AM #1
    nagesh.tvsr
    nagesh.tvsr is offline
    Forum Contributor
    Join Date
    02-15-2012
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2019
    Posts
    431

    Working days passed & left in the month / week

    Hi,

    Would like to get formula for calculating No. of working days passed / remaining for the current week / month.

    Excel file attached with relevant details.

    Pl. help.

    Thanks,
    Nagesh.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-09-2015, 08:41 AM #2
    [email protected]
    pangam_s@yahoo.com is offline
    Forum Contributor
    Join Date
    10-07-2011
    Location
    India, Mumbai
    MS-Off Ver
    Excel 2007
    Posts
    212

    Re: Working days passed & left in the month / week

    I Don't Understand month and week concept, but for days please find below formula
    No. of working days =NETWORKDAYS(A2,A366,C2:C63)
    Working days passed (Excluding today) =NETWORKDAYS(A2,TODAY()-1,C2:C63)
    Working days remaining (Including today) =E2-E3

    Hope it will work for you.

    Regards,
    Suhas
    Reply With QuoteRegister To Reply
  3. 01-09-2015, 08:48 AM #3
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Working days passed & left in the month / week

    Is saturday is working?
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
  4. 01-09-2015, 09:45 AM #4
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Working days passed & left in the month / week

    Does the attached help

    Put the 1st day of a month in F2 and a week number in F8

    If you wonder why January only shows 24 working days it's because you have listed 3 jan 2015 holidays in C54:C56
    Attached Files Attached Files
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  5. 01-09-2015, 10:15 AM #5
    sourabhg98
    sourabhg98 is offline
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Working days passed & left in the month / week

    Richard it says 24 coz there are 3 more holidays down in the holidays column
    I also got confused while preparing the formula...
    Reply With QuoteRegister To Reply
  6. 01-09-2015, 02:55 PM #6
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Working days passed & left in the month / week

    Quote Originally Posted by sourabhg98 View Post
    Richard it says 24 coz there are 3 more holidays down in the holidays column
    I also got confused while preparing the formula...
    Indeed, that's why I mentioned the cells C54:C56 in case the OP was similarly confused.
    Reply With QuoteRegister To Reply
  7. 01-12-2015, 05:14 AM #7
    nagesh.tvsr
    nagesh.tvsr is offline
    Forum Contributor
    Join Date
    02-15-2012
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2019
    Posts
    431

    Re: Working days passed & left in the month / week

    Hi Richard Buttrey,

    Thank you very much, but I have few queries.

    Pl. find the file attached with details.

    Thanks,
    Nagesh.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 01-12-2015, 05:16 AM #8
    nagesh.tvsr
    nagesh.tvsr is offline
    Forum Contributor
    Join Date
    02-15-2012
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2019
    Posts
    431

    Re: Working days passed & left in the month / week

    Saturday is working day. Issue almost solved with Richard Buttrey reply.

    Thanks,
    Nagesh.
    Reply With QuoteRegister To Reply
  9. 01-13-2015, 05:42 AM #9
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Working days passed & left in the month / week

    Please give some examples of the results you expect for say two different months and two different weeks. i.e. manually add the numbers youj expect to a couple of adjacent columns in the workbook.
    Reply With QuoteRegister To Reply
  10. 01-13-2015, 07:56 AM #10
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Working days passed & left in the month / week

    See the attached file
    Removed the all helper columns (Week Number Columns
    Attached Files Attached Files
    Last edited by samba_ravi; 01-13-2015 at 07:58 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Formula to show how many days have passed since the last day of the month
    By baby_gizmo87 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-13-2014, 09:03 AM
  2. find time left in month.days unit between two dates(in YEAR.MONTH.DAY)
    By xcfeng95 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 02-21-2014, 12:55 PM
  3. Excel Gurus brain required :) on averages on number of working days in the month/ week
    By skipton in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-28-2013, 12:20 PM
  4. [SOLVED] Dynamically calculate days that have passed in a month
    By sbaipsys in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-08-2012, 05:57 PM
  5. Working days left in the month compared to previous months
    By qwopzxnm in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-24-2005, 03:00 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