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