View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gibbyky2 Gibbyky2 is offline
external usenet poster
 
Posts: 13
Default 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