Forum Discussion

Brirack77's avatar
Brirack77
Copper Contributor
Dec 12, 2022
Solved

Calculate employee working and sick data over 365 days

Hi All, I have two sets of employee data that I currently plan to merge manually - I am looking for a quicker way that is also accurate for the full year. The first set is employee data (by role or ...
excel
Formulas and Functions
  • mtarler's avatar
    mtarler
    Dec 13, 2022

    Brirack77  wow that was more complicated than I would've guessed or I just over complicated it.  I bet one of the people good with power query might have an easier solution but in the attached I have a couple options.

mtarler's avatar
mtarler
Silver Contributor
Dec 13, 2022

Brirack77  wow that was more complicated than I would've guessed or I just over complicated it.  I bet one of the people good with power query might have an easier solution but in the attached I have a couple options.

  • Brirack77's avatar
    Brirack77
    Copper Contributor
    Dec 18, 2022
    that's incredible - thank you *tips hat*

Resources