KevinB
New Member
I am trying to get the months from a date or week number
The part that is complicating me is that I need the months to be in 4wk-4wk-5wk for the year, each Qtr ends with a 5 week month. I cant seem to figure out how to get this to work. I would think that there would be a way to get the month returned from the week number, ie. 1-4=Jan, 5-8=Feb, 9-13=Mar.
Am I missing something simple here?
The part that is complicating me is that I need the months to be in 4wk-4wk-5wk for the year, each Qtr ends with a 5 week month. I cant seem to figure out how to get this to work. I would think that there would be a way to get the month returned from the week number, ie. 1-4=Jan, 5-8=Feb, 9-13=Mar.
Am I missing something simple here?