PROJECTION WEEK, MONTH, YEAR

User avatar
sal21
PlatinumLounger
Posts: 4357
Joined: 26 Apr 2010, 17:36

PROJECTION WEEK, MONTH, YEAR

Post by sal21 »

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

User avatar
HansV
Administrator
Posts: 78500
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: PROJECTION WEEK, MONTH, YEAR

Post by HansV »

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.
Best wishes,
Hans