Returning month number from calendar week....

[dan_l]

One of my olap gadgets drops out date series calendar week. I need to return the month associated with that week using vba. It's actually part of a vba driven automation routine, so I could probably insert a formula wit hvba, I"m just having trouble cooking up the vba to do it.


40.2012
41.2012
42.2012
43.2012
44.2012
45.2012
46.2012
47.2012
48.2012
49.2012
50.2012

 

[NARAYANK991]

Hi Dan ,

Does this link help ?

http://www.mrexcel.com/forum/excel-questions/126250-getting-excel-display-month-week-number.html

Narayan

 

[dan_l]

I think I can work with this. Thanks Narayank.

 

[SirJB7]

Hi, dan_l!
Regarding the week number maybe you want to give a look at this link:
http://chandoo.org/forum/threads/creating-week-number-not-starting-on-1-jan-solved.10990/#post-64131
I think that it'll all depend on what have you told your OLAP gadget to consider the first week of the year and its starting day.
Regards!