Calculation with Working day of the year
 

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?

Calculation with Working day of the year
 

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

Calculation with Working day of the year
 

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?

Calculation with Working day of the year
 

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

Calculation with Working day of the year
 

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