ScottUlmer
New Member
- Joined
- Dec 13, 2016
- Messages
- 29
I have a data set that could be used for a pivot table. I need to be able to know what the current rotation is. The number of employees and length of time of each rotation is different. For example
today = 12/18/16
The three rotation dates are:
11/1/16
1/9/17
3/6/17
Since today is > 11/1 but less than 1/19 the current rotation would be the 11/1 rotation. However, on 1/9, I need it to know 1/9 is current and 3/6 is next. The issue I am running into is I need a dynamic number employees and can't just say monthly on the same date go to next.
So in theory, I need a formula that is if today > A# check A#+1, repeat until A# >=today.
today = 12/18/16
The three rotation dates are:
11/1/16
1/9/17
3/6/17
Since today is > 11/1 but less than 1/19 the current rotation would be the 11/1 rotation. However, on 1/9, I need it to know 1/9 is current and 3/6 is next. The issue I am running into is I need a dynamic number employees and can't just say monthly on the same date go to next.
So in theory, I need a formula that is if today > A# check A#+1, repeat until A# >=today.