Hello, I am working on automating my monthly timesheet allocations and one of the early steps is to simply calculate the number of weekdays in a given month.
My monthly timesheet (which provides the details for each task) has been imported into Exploratory and the number of hours has been summarized by project name.
The goal is to be able to multiply the number of weekdays in January 2021 by 8 to calculate the expected hours, and then split the overhead hours over the other three categories proportionally.
What is a good way to accomplish this goal?
(This is a process I have been doing in Excel for years, but I would love to just be able to import the timesheet and run a script for each month in 2021.)
Thanks in advance!