Need an Excel format design that can distinguish and automatically count only certain individuals within a limited range of dates. The design must count a single subject individual who has completed 12 consecutive months of employment after one year of employment, and then add all other employees on the list who are also employed on that same day as the subject employee who just completed his one year of employment. All employees on the list have independent qualifying periods that begin on their initial date of hire. In other words, all qualifying one-year periods are on the basis of separate rolling 12-month periods.
37 freelancers are bidding on average $119 for this job
Hi there. Let me build you an Excel template so that you will put your data in and make the counting / distinguishing issue. Im mostly online. Let me know. Thanks..
Hello, I can program a solution to this problem in VBA for Excel. I would need an attachment to better understand and clarify some points of the project. Regards