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