Results 1 to 8 of 8

DAYS function: correctly calculating the number of days

Threaded View

dadpad DAYS function: correctly... 08-25-2015, 07:51 PM
Tony Valko Re: DAYS function: correctly... 08-25-2015, 07:57 PM
John90 Re: DAYS function: correctly... 08-25-2015, 08:15 PM
Tony Valko Re: DAYS function: correctly... 08-25-2015, 08:17 PM
dadpad Re: DAYS function: correctly... 08-25-2015, 08:25 PM
Tony Valko Re: DAYS function: correctly... 08-25-2015, 08:30 PM
dadpad Re: DAYS function: correctly... 08-25-2015, 08:53 PM
Tony Valko Re: DAYS function: correctly... 08-25-2015, 09:18 PM
  1. 08-25-2015, 07:51 PM #1
    dadpad is offline
    Registered User
    Join Date
    07-29-2015
    Location
    Australia
    MS-Off Ver
    excel
    Posts
    11

    DAYS function: correctly calculating the number of days

    I'm using the Days function to calculate the number of days between certain dates.

    Days function does not include 1 of either the start of finish date. Thus if I input [ A1]01/01/15 [A2]31/01/15 [A3]=days(A1,A2) A3 returns 30 as per attachment.
    similarly 01/01/15 - 31/12/15 = 364.

    It would be be a simple matter to modify the return to =days(A1,A2)+1 however I wondered if there was a better function available?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Calculating Market Days (excluding weekends, holidays) & short days between two dates/time
    By trw57 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-31-2014, 10:32 AM
  2. Calculating number of days, help.
    By DollyMixture in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-23-2014, 11:01 AM
  3. Calculating days in between 2 dates (which have after 14 days issued date)
    By husni in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-20-2014, 06:40 AM
  4. [SOLVED] Calculating days between days by individual person
    By mistert in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-22-2013, 02:18 AM
  5. [SOLVED] Calculating the number of days
    By bremen22 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-09-2013, 12:06 PM
  6. calculating the number of days
    By Deanomcbeano in forum Excel General
    Replies: 12
    Last Post: 10-02-2012, 08:22 AM
  7. Calculating time elapsed in days and count days within same range
    By michellem410 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-19-2008, 01:13 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