Calculate Difference in Sequential Dates in One Date Field
Existing Data Structure is as under:
Requirement:
A formula is required to calculate the total duration an Employee spent in a particular grade and branch.
The value is to be entered in a separate columns called 'Duration in Grade' and 'Duration in Branch'
I guess a conditional DATEDIF should meet the requirement.
Thanks in Advance
Regards
Existing Data Structure is as under:
Sl | Name | Grade | Branch | Date | Remarks | Duration in Grade | Duration in Branch |
1 | Employee A | Grade 2 | Branch 1 | 12-04-2015 | 464 | 1081 | |
2 | Employee B | Grade 2 | Branch 2 | 12-04-2015 | |||
3 | Employee C | Grade 2 | Branch 3 | 12-04-2016 | |||
4 | Employee A | Grade 3 | Branch 1 | 18-07-2016 | Upgradation | 618 | 1081 |
5 | Employee A | Grade 4 | Branch 3 | 28-03-2018 | Upgradation & Transfer | 942 | 440 |
6 | Employee B | Grade 2 | Branch 1 | 12-04-2015 | |||
7 | Employee A | Grade 4 | Branch 6 | 11-06-2019 | Transfer | 502 |
Requirement:
A formula is required to calculate the total duration an Employee spent in a particular grade and branch.
The value is to be entered in a separate columns called 'Duration in Grade' and 'Duration in Branch'
I guess a conditional DATEDIF should meet the requirement.
Thanks in Advance
Regards