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

1. ## 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. ## Re: Calculate Number of Days between multiple dates in the same calendar year for pror

Have you looked into the DAYS360() function?

3. ## 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. ## 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

5. ## 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:

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.

7. ## 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. ## 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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### 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