Forum

Notifications
Clear all

Calculating length of service from start date to termination date OR if no termination date, from data export date in another cell

2 Posts
1 Users
0 Reactions
158 Views
(@Anonymous)
Posts: 0
New Member Guest
 

Hi there!  I'm trying to wrangle my data to recreate Mynda's awesome HR Dashboard, as my HRIS program will not export what I need.  What I'm stuck on at the moment is trying to calculate a length of service (tenure), either to a termination date, or if there is no termination date, to the data export date in the spreadsheet.  

Would appreciate any help, thank you!!

 
Posted : 29/08/2022 4:06 am
(@Anonymous)
Posts: 0
New Member Guest
 

Don't worry, I actually figured it out!!!  I'm so proud of myself!  🙂

 
Posted : 30/08/2022 12:20 am
Share: