Calculating number of workdays between 2 dates
here goes
i use excel 2007 and can calculate number of days between 2 dates using
networkdays function. but my colleagues use older versions of excel and
networkdays function does not work
i want to work out the example below as an example
1st date = 09/10/09
2nd date = 23/10/09
this equals 10 working days, i then want to be able to calculate the number
of days by 7.4 (average hours worked per day)
many thanks
|