Hello All,
I'm stuck triyng to figure this out and could use your help. I am trying to calculate the total number of days excluding weekends and holidays. In column A I have the start date (1/2/2008 9:00 am), in column B I have the End date (1/8/2008 4:33 pm). In column C I would like to display the total number of days ( to 2 places (6.45)) excluding weekends and holidays. I tried networkdays but that only gives me whole numbers. Any help will be greatly appreciated.
Thanks
I'm stuck triyng to figure this out and could use your help. I am trying to calculate the total number of days excluding weekends and holidays. In column A I have the start date (1/2/2008 9:00 am), in column B I have the End date (1/8/2008 4:33 pm). In column C I would like to display the total number of days ( to 2 places (6.45)) excluding weekends and holidays. I tried networkdays but that only gives me whole numbers. Any help will be greatly appreciated.
Thanks