Hey there,
I currently have a table with columns for "Orientation Date" and "Retired Date." I entered a formula to give me the amount of networkdays between the 2 dates, however the outcome is negative if there isn't a retired date entered. My end goal is to have a chart of the average amount of days (obviously only the positive numbers) these employees were employed and ignore those who are still employed (the negative numbers).
Thank you in advance!
Bookmarks