Hi there,
I hope someone can help me with my problem.
I have a problem with the calculation of dates. We have certain periods given and people who have been working within these periods. The problem is that the time the people stay is overlapping with the ends of the periods.
So I'd like to know how many days the people actually stayed in the respective periods.
Thanks for your effort.
Last edited by Lennakame; 05-24-2010 at 05:26 AM.
I had to change your data layout a little to make it work. I changed the dates because I needed to make sure it worked correctly if the dates fell on the first or last of a period.
Basically, it's a sequence of IF statements for 4 different possibilities:
I: dates are entirely within a period
II: dates start in current period and end in a later one
III: dates overlap the period completely
IV: dates start in a prior period and end in the current one
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks