Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Number of Weeks in Month

Status
Not open for further replies.

txwylde

Programmer
Jan 25, 2001
60
US
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
 
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).

Brian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top