I currently have a macro made in Excel to add a new column to my data and calculate the networkingdays.
I would like to modify the code or add a new code , that will calculate the median and the mode at the bottom of the Net work Days column , for each one of my sheet.
then to have a new sheet created at the end with the result for each sheet .
so basically it will have
Here is the original question with the macro created for me .
Thanks in Advance.