+ Reply to Thread
Results 1 to 8 of 8

Calculate Number of Days between multiple dates in the same calendar year for pror

  1. #1
    Registered User
    Join Date
    01-05-2012
    Location
    san francisco
    MS-Off Ver
    Excel 2007
    Posts
    6

    Calculate Number of Days between multiple dates in the same calendar year for pror

    Hi all,

    I am looking for a formula that calculates the number days within the same calendar year for multiple dates. example-

    POSITION 1 START DATE POSITION 2 START DATE POSITION 3 START DATE Days@POS 1 Days@POS 2 Days@POS 3

    1/1/2014 9/8/2014 - 250 115

    Also, if their is no date in Position 2 Start Date, then Days@POS 1 should read as 365 days instead of 250.

    I have tried a combination of iF and or functions together and can't seem to make any progress. Any help will be greatly appreciated. Thanks.

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Calculate Number of Days between multiple dates in the same calendar year for pror

    Have you looked into the DAYS360() function?
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  3. #3
    Registered User
    Join Date
    01-05-2012
    Location
    san francisco
    MS-Off Ver
    Excel 2007
    Posts
    6

    Calculate Number of Days between multiple dates in the same calendar year for pror

    Hi all,

    I am looking for a formula that calculates the number days within the same calendar year for multiple dates. example-

    POSITION 1 START DATE POSITION 2 START DATE POSITION 3 START DATE Days@POS 1 Days@POS 2 Days@POS 3

    1/1/2014 9/8/2014 - 250 115

    Also, if their is no date in Position 2 Start Date, then Days@POS 1 should read as 365 days instead of 250.

    I have tried a combination of iF and or functions together and can't seem to make any progress. Any help will be greatly appreciated. Thanks.

  4. #4
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Calculate Number of Days between multiple dates in the same calendar year for pror

    So are you looking for an infinite amount of potential dates and is each the difference to the one before it? or are they all the difference to date 1?

    eg Days@POS2 = Date2 - Date1
    Days@POS3 = Date 3 - Date2

    etc
    If someone has helped you then please add to their Reputation

  5. #5
    Registered User
    Join Date
    01-05-2012
    Location
    san francisco
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Calculate Number of Days between multiple dates in the same calendar year for pror

    I am using the Below function in Days@POS 1 column:

    IF(AD2<>"0",AI2-AD2,$BO$1-AD2) where

    AD2 = Position Start Date 1
    AI2 = Position Start Date 2
    BO1= 12/31/2014

    I want the function to say if AI2 field is blank, then it should be 365 days based on BO1-AD2.

  6. #6
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Calculate Number of Days between multiple dates in the same calendar year for pror

    Don't open duplicated threads. They are merged now into one thread.

  7. #7
    Registered User
    Join Date
    01-05-2012
    Location
    san francisco
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Calculate Number of Days between multiple dates in the same calendar year for pror

    For majority of the population, it'll be to Date 1 but in some cases it'll be date 2 or Date 3 depending if the employee changed positions.

  8. #8
    Registered User
    Join Date
    01-05-2012
    Location
    san francisco
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Calculate Number of Days between multiple dates in the same calendar year for pror

    sorry. i hit the reply to the thread button by mistake. mean to hit post quick reply.

+ 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] How to calculate number of days per year a customer is a member
    By Even in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-12-2014, 11:07 AM
  2. [SOLVED] How to calculate Year, Month and Day from total number of days?
    By Indra Rai in forum Excel General
    Replies: 4
    Last Post: 06-25-2014, 02:08 PM
  3. Replies: 15
    Last Post: 06-03-2014, 02:08 PM
  4. Replies: 4
    Last Post: 11-28-2011, 06:21 AM
  5. Replies: 2
    Last Post: 04-23-2008, 12:21 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