I have a variable called Paid Month which gives the date as 200312. How can I go about creating a variable which gives me the number of weeks in that particular month?
Thanks
Bill
If you create a variable for the first of the month, and another for the first day of the subsequent month, you can use the WEEK function to find the financial week for each month start. Subtraction gives the number of weeks which start in the month (being careful about year changes).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.