Hi all,
I have a users file which has their date of joining (all users) and date of exit (only for users which have left). This data is maintained since Jan 2016.
What I want help with is- I have all months since Jan 2016 till date listed in column A of a sheet. I want to formulate a countif (or any other function) which can tell me how many employees were available in that month.
I hope I have been able to put this in an easy manner for you to understand, if not I can elucidate.
Regards
Bookmarks