yuvaraj859
New Member
- Joined
- Dec 5, 2021
- Messages
- 4
- Office Version
- 2010
- Platform
- Windows
Hi ,
How to split the year or monthly demand to weekly demand for the every month
for example - Dec monthly demand is 5648 , working days is 27 ( excluding sunday ) avg per day is 209, 1st week should be 837, 2nd wk -1255, 3rd wk -1255, 4th wk -1255 , 5th wk -1046.
like this every month how can i spilt ,
can anyone tell any formula or macros for this
How to split the year or monthly demand to weekly demand for the every month
for example - Dec monthly demand is 5648 , working days is 27 ( excluding sunday ) avg per day is 209, 1st week should be 837, 2nd wk -1255, 3rd wk -1255, 4th wk -1255 , 5th wk -1046.
like this every month how can i spilt ,
can anyone tell any formula or macros for this