Using the "standard formula" I am able to work out that (say)the 21st
June is working day 117 for this year using
=NETWORKDAYS($U$4;B17;$V$3:$AE$5)- where U4 is 01/01/2005, B17 is
21/06/2005 and V3 to AE5 is a list of non working days.

I now need to know what working day 117 was last year, is it possible
to start with working day no. and then work out the date?

On 10 Nov 2005 07:01:34 -0800, "Box666" wrote:

Using the "standard formula" I am able to work out that (say)the 21st
June is working day 117 for this year using
=NETWORKDAYS($U$4;B17;$V$3:$AE$5)- where U4 is 01/01/2005, B17 is
21/06/2005 and V3 to AE5 is a list of non working days.

I now need to know what working day 117 was last year, is it possible
to start with working day no. and then work out the date?

Look at the WORKDAY formula:

=WORKDAY(DATE(2004,1,1),117,holidays)

Be sure to include the holiday (non-working) day dates in the holidays range.


--ron

Use the WORKDAY() function; WORKDAY(A1,117,holidays) where A1 is 1-1-2004
and holidays contain last years's non working days

--
Kind regards,

Niek Otten

"Box666" wrote in message
oups.com...
Using the "standard formula" I am able to work out that (say)the 21st
June is working day 117 for this year using
=NETWORKDAYS($U$4;B17;$V$3:$AE$5)- where U4 is 01/01/2005, B17 is
21/06/2005 and V3 to AE5 is a list of non working days.

I now need to know what working day 117 was last year, is it possible
to start with working day no. and then work out the date?

Ron,
Thank you spot on, I do not seem to have the logical thinking to
work these things backwards.. but when I see the answer i realise how
"obvious" it is.

Thanks

Bob

On 10 Nov 2005 08:27:34 -0800, "Box666" wrote:

Ron,
Thank you spot on, I do not seem to have the logical thinking to
work these things backwards.. but when I see the answer i realise how
"obvious" it is.

Thanks

Bob

You're welcome. Glad to help. Sometimes it's interesting to find a function
that I did not know existed.


--ron