View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jeanmac jeanmac is offline
external usenet poster
 
Posts: 1
Default Networkdays function

Hi, I've been using the Networkdays function to work out the date 7 days
previous to today minus working days. I'm doing it in two stages, eg cell A1
= today(), cell A2 = 7, cell A3 = A1-A2, Cell A4 = Networkdays(A3, A1).
However, it comes back with the answer 6 when I would expect to see 5. Does
anyone know why that should happen? Also is there a quicker way of doing
this? Help would be much appreciated. Thanks. Jean