| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic calculation is not working | Excel Discussion (Misc queries) | |||
| Commission Calculation | Excel Worksheet Functions | |||
| Working days left in the month compared to previous months | Excel Worksheet Functions | |||
| Is the IRR calculation based on cash flows at beginning of year? | Excel Worksheet Functions | |||
| Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
