Date calculation if end date is not always used
I am trying to calulate two date fields "Start Date" and "End Date". I've been using
Year ( Get (CurrentDate) ) -
Year ( Start Date )
to tell me how many years someone has been working with us. Ideally, what I want to calculate is how many years and months someone has been working with us. The "End Date" however, is not always a used field in cases where the employee is still working for us.
How would I set up this calculation to calculate in Years and Months:
Current Employee: how long they have been with us (End Date is blank)?
Past Employee: how long they have been with us (End Date is filled out)?
Thanks for your help!