Bsased myvar=130,65 is redfered a one day, how to calculate the projection for:
week a month and year
???
Note:
- naturally i need to calculate based only for workday
- myvar is Double dimensioned
PROJECTION WEEK, MONTH, YEAR
-
- Administrator
- Posts: 78500
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: PROJECTION WEEK, MONTH, YEAR
For a week it would be 5 * myvar
For a month, it depends on the month of course, but on average it would be 21.7 * myvar
For a year, it would be 260.8 * myvar
This only takes weekends into account, not holidays.
For a month, it depends on the month of course, but on average it would be 21.7 * myvar
For a year, it would be 260.8 * myvar
This only takes weekends into account, not holidays.
Best wishes,
Hans
Hans