View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PO PO is offline
external usenet poster
 
Posts: 66
Default Calculating number of workdays

Hello,

I need to calculate the number of working days (monday to friday) between
two dates.
For example: the number of working days between 2006-08-25 and 2006-08-28
should be 1, since the 26th and 27th are saturday and sunday. The datediff
function however returns 3.

Is there another function I can use or do I have to write a custom function?

Regards
PO