Thread: Dates calculation using working days
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
oldchippy oldchippy is offline
external usenet poster
  
Posts: 1
Default Dates calculation using working days

Javier Wrote:
Hi everybody,

I would like to know how is it possible to subtract 2 diferent dates
and
counting only working days inside the formula.

Thank you


Try this

A1 = 01/07/2006
B1 = 31/07/2006
C1 =NETWORKDAYS(A1,B1)
Answer 21

Is this what you need?:)

oldchippy


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=563307

Reply With QuoteReply With Quote