Networkdays function
Hi,
I'm not surprised you get 6 because networkdays includes the start and end
date.
For example there are 5 network days between 1/1/2007 and 5/1/2007
so in your case going back 7 days from today takes us to 6/7/2007 which is
last Friday and Friday to Friday is 6 network days.
An easier way
=NETWORKDAYS(TODAY()-7,TODAY())
Mike
"jeanmac" wrote:
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
|