Forum Discussion
Calculating Employee Age by Month
Hi again, if it helps I know from the data that 2169 roles were in existence as at 1st Sept 2021 and that the average of all employee ages associated with those roles equates to 47.38. This is the figure I would like to see as a total against Sept-21. Let me know if a link to the data in Excel would help.
Would really appreciate any help on this one - thanks 🙂
- TheoC
Community Champion
Hi Anonymous
Massive thanks for the additional information and the data link would be very beneficial!
I am on phone until the morning but will get you a solution first thing (8.20pm in Brisbane), unless one of the insanely talented / gifted members in the Community respond with it first.
Either way, you will have a solution within 12 hours 🙂
Thanks so much TheoC. Christmas might actually come early for once!! This has been an ongoing nightmare for a whole week now, so another 12 hours certainly won't hurt!!
Link to the data in Excel if that helps ...... https://1drv.ms/x/s!AkENRXlfBIJKig9xz9eUmLvxHFOS?e=1MNfBt
Anything to the right of column I on the Role_Ref worksheet is just my crude workings giving me an idea as to what I should be seeing against each company, for each month start date.
Please shout if you cannot access the link, or if there is anything you feel I haven't been entirely clear about.
- TheoC
You're a legend Anonymous. Thank you! Will touch base in the morning and look forward to speaking soon!
Theo 😀
