Hi , I am try to find out the difference in multiple dates of rehire up to six times.
I have a start and end date , rehire date, The issues I have is try to subtract the date difference or length service & calculation must include 30 day calender every month and com
=DATEDIF(E3,B4+((E4-D4)+(E3-D3)),"md")&" Days, "&DATEDIF(E3,E3+((E4-D4)+(E3-D3)),"ym") &" Months , "&DATEDIF(E3,E3+((E4-D4)+(E3-D3)),"y")&" Years"
B4 : rehire date
E3: start date
D3: seperation date
I also have to minus three dates to come up with a new rehire date. please hep
Bookmarks