Results 1 to 5 of 5

Thread: calculating "days taken" thus far
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Nov 2016
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Talking calculating "days taken" thus far

    Hi all,

    Perhaps a very simple one - I'm trying to give an average of time taken for a team to process a quote to a customer. my table has three columns:


    start date, end date and days taken (to process quotes) in another column I would like to calculate the running total of days taken to process the quote which will then stop counting once an 'end date' has been entered in the other column? This is so at any time I can get an accurate idea of how long it is taking us to process a quote.

  2. #2
    Board Regular
    Join Date
    Sep 2016
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: calculating "days taken" thus far

    Something like this you mean(assuming start date,end date and days taken are in columns A,B,C respectively):

    =IF(B2="",TODAY()-A2,"Completed")

    This will include weekends by the way.

  3. #3
    Board Regular
    Join Date
    Oct 2013
    Location
    Belo Horizonte, Brazil
    Posts
    695
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    1 Thread(s)

    Default Re: calculating "days taken" thus far

    excelbeginner3, Good afternoon.

    Suppose:

    A1 --> START DATE
    B1 --> END DATE
    Both cells formatted as DATE

    C1= DAYS TAKEN --> FORMULA
    Formatted as NUMBER

    =IF(B1="", TODAY()-A1, B1-A1)

    Is that what you want?
    I hope it helps.

  4. #4
    Board Regular texasalynn's Avatar
    Join Date
    May 2002
    Location
    Houston, TX
    Posts
    8,458
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: calculating "days taken" thus far

    try this
    A B C
    6 Start Date End Date Days Taken
    7 8/11/2016 98
    formula for days taken
    =IF(B7="",TODAY()-A7,B7-A7)

  5. #5
    MrExcel MVP Tetra201's Avatar
    Join Date
    Oct 2016
    Posts
    3,417
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    1 Thread(s)

    Default Re: calculating "days taken" thus far

    The following formula counts only weekdays taken (no weekends):

    =NETWORKDAYS(A2,IF(B2="",TODAY(),B2))

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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