Hello, I have a spreadsheet with hire dates listed in a column. I need to count the duration of time between the hire date and a date in another column. I want the return answer to show in year, mont... Stasha_MAPITry this: =DATEDIF(B3,F3,"Y")&"yr, "&DATEDIF(B3...
I need to count the duration of time between the hire date and a date in another column. I want the return answer to show in year, month and days. I am using the function listed below which gives me the number of years, but what do I add to that function ...
However, using your formula bring me the total employee today, rather than per month, in my case I get 27 each month for all the years (which is the total employees today), what am I doing wrong? By the way, I must mention that I dont have an end date for each...
We use optional cookies to improve your experience on our websites, such as through social media connections, and to display personalized advertising based on your online activity. If you reject optional cookies, only cookies necessary to provide you t...