+ Reply to Thread
Results 1 to 9 of 9

Creating a Date Count Formula

Hybrid View

  1. #1
    Registered User
    Join Date
    09-20-2012
    Location
    Jacksonville, FL
    MS-Off Ver
    Excel 2007
    Posts
    80

    Question Creating a Date Count Formula

    I am trying to figure a formula that will calculate a turn around or total number of days it takes to completre a process.

    For example, with the attached file I want to place formula's in column K (Titled: Turn Around Time) that will calculate from the total number of days it took from the time an invoice was submitted to Acctg to the date a check was issued (Check Date).


    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Creating a Date Count Formula

    Try this.......

    =IF(I4="","",I4-G4)
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Registered User
    Join Date
    09-20-2012
    Location
    Jacksonville, FL
    MS-Off Ver
    Excel 2007
    Posts
    80

    Re: Creating a Date Count Formula

    I'm not sure that I understand the second formula you submitted. Are you able to do one in the attachment so I can see?
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    667

    Re: Creating a Date Count Formula

    =(Month(A2)-Month(A1))+((Year(A2)-Year(A1))*12)
    A2 is the second date A1 is the first date

  5. #5
    Registered User
    Join Date
    09-20-2012
    Location
    Jacksonville, FL
    MS-Off Ver
    Excel 2007
    Posts
    80

    Re: Creating a Date Count Formula

    No it didn't work it only gave me a result of 1/6/1900

  6. #6
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Creating a Date Count Formula

    Quote Originally Posted by tdsmith14 View Post
    No it didn't work it only gave me a result of 1/6/1900
    Change the format of col. K to General which is right now is a date format.

    See the attached sheet.
    Attached Files Attached Files
    Last edited by sktneer; 11-22-2013 at 12:31 PM.

  7. #7
    Registered User
    Join Date
    11-20-2013
    Location
    Las Vegas, NV
    MS-Off Ver
    Excel 2010
    Posts
    64

    Re: Creating a Date Count Formula

    Try this: =DATEDIF(A1,A2,"D")+1

    A1 = your start date, A2 your end.

  8. #8
    Registered User
    Join Date
    09-20-2012
    Location
    Jacksonville, FL
    MS-Off Ver
    Excel 2007
    Posts
    80

    Re: Creating a Date Count Formula

    Understood. Thanks a bunch :-)

  9. #9
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Creating a Date Count Formula

    Glad to help you. Thanks for the feedback and Rep.

+ 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. Replies: 1
    Last Post: 05-26-2013, 09:48 AM
  2. [SOLVED] Need help with creating formula to count cells based on 2 criterias
    By Titleistseemore in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-11-2013, 03:00 AM
  3. [SOLVED] creating a count formula that looks at multiple criteria
    By jdrobin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-09-2013, 07:16 PM
  4. Replies: 1
    Last Post: 06-26-2012, 05:02 PM
  5. Creating a Count formula
    By Shelyna in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-30-2006, 05:15 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