+ Reply to Thread
Results 1 to 3 of 3

I would like to show work days lapsed from today's date

  1. #1
    Registered User
    Join Date
    09-10-2014
    Location
    Lexington, KY
    MS-Off Ver
    2013
    Posts
    39

    I would like to show work days lapsed from today's date

    Hello. I would like help with a formula that would calculate work days lapsed using a cell with a start date and a cell with the '=Today()' function.

    Thank you.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    18,133

    Re: I would like to show work days lapsed from today's date

    If the start date is in A1, the elapsed workdays is given by

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    where the third argument is an optional range reference containing a list of dates for weekdays that are non-working days. Please look up Excel Help for NETWORKDAYS for a complete explanation.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    09-10-2014
    Location
    Lexington, KY
    MS-Off Ver
    2013
    Posts
    39

    Re: I would like to show work days lapsed from today's date

    Thank you so much for the formula. Before I read your reply I tried out the following formula...

    =A1-(WORKDAY(E4,5))

    Where A1 has '=Today()' and E4 has a starting date and 5 is the number of work days for the week. I will do as you suggest and read up on NETWORKDAYS.

    Thank you again!

+ 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. [SOLVED] Remaining work days in current quarter from today
    By jackson_hollon in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-07-2014, 02:41 PM
  2. Three if statements to calculate number of days lapsed
    By janetk411 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-25-2012, 03:55 PM
  3. [SOLVED] sort by date, show records with only dates less than 30 days from today, and count....
    By pbucc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-22-2012, 12:11 PM
  4. Replies: 10
    Last Post: 01-04-2012, 10:03 AM
  5. Re: how to work out how many days from date to today
    By Melville in forum Excel General
    Replies: 2
    Last Post: 07-05-2010, 07:21 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