Calculation with Working day of the year

[Box666]

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 Rosenfeld]

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

 

[Niek Otten]

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

 

[Box666]

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

 

[Ron Rosenfeld]

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