If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




How do you calculate the number of weeks on a month
Morning from beautiful RSA,
Looking for an excel formula to calculate the number of weeks in a month, using a date inputted in cell F2  usually the 1st of the month. Thanks in advance. 
Ads 
#2




How do you calculate the number of weeks on a month
What is the criteria for a week? Does November have 4 or 5, and how do you
determine?   HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sunnyskies" > wrote in message ... > Morning from beautiful RSA, > > Looking for an excel formula to calculate the number of weeks in a month, > using a date inputted in cell F2  usually the 1st of the month. > > Thanks in advance. 
#3




How do you calculate the number of weeks on a month
November would have 5, December would be 6, January 5
"Bob Phillips" wrote: > What is the criteria for a week? Does November have 4 or 5, and how do you > determine? > >  >  > HTH > > Bob > > (there's no email, no snail mail, but somewhere should be gmail in my addy) > > > > "Sunnyskies" > wrote in message > ... > > Morning from beautiful RSA, > > > > Looking for an excel formula to calculate the number of weeks in a month, > > using a date inputted in cell F2  usually the 1st of the month. > > > > Thanks in advance. > > > 
#4




How do you calculate the number of weeks on a month
And why as I said earlier is that the case, what are the criteria?
  HTH Bob __________________________________________ UK Cambridge XL Users Conference 2930 Nov http://www.exceluserconference.com/UKEUC.html (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sunnyskies" > wrote in message ... > November would have 5, December would be 6, January 5 > > "Bob Phillips" wrote: > >> What is the criteria for a week? Does November have 4 or 5, and how do >> you >> determine? >> >>  >>  >> HTH >> >> Bob >> >> (there's no email, no snail mail, but somewhere should be gmail in my >> addy) >> >> >> >> "Sunnyskies" > wrote in message >> ... >> > Morning from beautiful RSA, >> > >> > Looking for an excel formula to calculate the number of weeks in a >> > month, >> > using a date inputted in cell F2  usually the 1st of the month. >> > >> > Thanks in advance. >> >> >> 
#5




How do you calculate the number of weeks on a month
A criteria for a week is from Sunday to Saturday. So if the 1st is on a
Saturday it is still one week, if the 31st is on a Sunday it is also still one week. I hope this makes clearer sense? Thanks "Bob Phillips" wrote: > And why as I said earlier is that the case, what are the criteria? > >  >  > HTH > > Bob > > __________________________________________ > UK Cambridge XL Users Conference 2930 Nov > http://www.exceluserconference.com/UKEUC.html > > (there's no email, no snail mail, but somewhere should be gmail in my addy) > > > > "Sunnyskies" > wrote in message > ... > > November would have 5, December would be 6, January 5 > > > > "Bob Phillips" wrote: > > > >> What is the criteria for a week? Does November have 4 or 5, and how do > >> you > >> determine? > >> > >>  > >>  > >> HTH > >> > >> Bob > >> > >> (there's no email, no snail mail, but somewhere should be gmail in my > >> addy) > >> > >> > >> > >> "Sunnyskies" > wrote in message > >> ... > >> > Morning from beautiful RSA, > >> > > >> > Looking for an excel formula to calculate the number of weeks in a > >> > month, > >> > using a date inputted in cell F2  usually the 1st of the month. > >> > > >> > Thanks in advance. > >> > >> > >> > > > 
#6




How do you calculate the number of weeks on a month
Thanks, got it now
=4+(DAY(F2DAY(F2)+35)<WEEKDAY(F2DAY(F2)1))+(WEEKDAY(F2)<>1)   HTH Bob __________________________________________ UK Cambridge XL Users Conference 2930 Nov http://www.exceluserconference.com/UKEUC.html (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sunnyskies" > wrote in message ... >A criteria for a week is from Sunday to Saturday. So if the 1st is on a > Saturday it is still one week, if the 31st is on a Sunday it is also still > one week. > > I hope this makes clearer sense? > > Thanks > > "Bob Phillips" wrote: > >> And why as I said earlier is that the case, what are the criteria? >> >>  >>  >> HTH >> >> Bob >> >> __________________________________________ >> UK Cambridge XL Users Conference 2930 Nov >> http://www.exceluserconference.com/UKEUC.html >> >> (there's no email, no snail mail, but somewhere should be gmail in my >> addy) >> >> >> >> "Sunnyskies" > wrote in message >> ... >> > November would have 5, December would be 6, January 5 >> > >> > "Bob Phillips" wrote: >> > >> >> What is the criteria for a week? Does November have 4 or 5, and how do >> >> you >> >> determine? >> >> >> >>  >> >>  >> >> HTH >> >> >> >> Bob >> >> >> >> (there's no email, no snail mail, but somewhere should be gmail in my >> >> addy) >> >> >> >> >> >> >> >> "Sunnyskies" > wrote in message >> >> ... >> >> > Morning from beautiful RSA, >> >> > >> >> > Looking for an excel formula to calculate the number of weeks in a >> >> > month, >> >> > using a date inputted in cell F2  usually the 1st of the month. >> >> > >> >> > Thanks in advance. >> >> >> >> >> >> >> >> >> 
#7




How do you calculate the number of weeks on a month
I would never had gotten that right.
Works great, thanks. "Bob Phillips" wrote: > Thanks, got it now > > =4+(DAY(F2DAY(F2)+35)<WEEKDAY(F2DAY(F2)1))+(WEEKDAY(F2)<>1) > >  >  > HTH > > Bob > > __________________________________________ > UK Cambridge XL Users Conference 2930 Nov > http://www.exceluserconference.com/UKEUC.html > > (there's no email, no snail mail, but somewhere should be gmail in my addy) > > > > "Sunnyskies" > wrote in message > ... > >A criteria for a week is from Sunday to Saturday. So if the 1st is on a > > Saturday it is still one week, if the 31st is on a Sunday it is also still > > one week. > > > > I hope this makes clearer sense? > > > > Thanks > > > > "Bob Phillips" wrote: > > > >> And why as I said earlier is that the case, what are the criteria? > >> > >>  > >>  > >> HTH > >> > >> Bob > >> > >> __________________________________________ > >> UK Cambridge XL Users Conference 2930 Nov > >> http://www.exceluserconference.com/UKEUC.html > >> > >> (there's no email, no snail mail, but somewhere should be gmail in my > >> addy) > >> > >> > >> > >> "Sunnyskies" > wrote in message > >> ... > >> > November would have 5, December would be 6, January 5 > >> > > >> > "Bob Phillips" wrote: > >> > > >> >> What is the criteria for a week? Does November have 4 or 5, and how do > >> >> you > >> >> determine? > >> >> > >> >>  > >> >>  > >> >> HTH > >> >> > >> >> Bob > >> >> > >> >> (there's no email, no snail mail, but somewhere should be gmail in my > >> >> addy) > >> >> > >> >> > >> >> > >> >> "Sunnyskies" > wrote in message > >> >> ... > >> >> > Morning from beautiful RSA, > >> >> > > >> >> > Looking for an excel formula to calculate the number of weeks in a > >> >> > month, > >> >> > using a date inputted in cell F2  usually the 1st of the month. > >> >> > > >> >> > Thanks in advance. > >> >> > >> >> > >> >> > >> > >> > >> > > > 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
How do I count the number of even weeks in the current month.  dd  Excel Worksheet Functions  6  February 22nd 07 07:29 AM 
Calculate Number of Months Weeks and Days Between Two Dates  [email protected]  Excel Worksheet Functions  4  September 22nd 06 01:47 AM 
Calculate number of weeks between dates in Excel 2000  Darlene  Excel Discussion (Misc queries)  4  May 31st 06 09:13 PM 
HOW TO CALCULATE NUMBER OF WEEKS BETWEEN TWO GIVEN DATES(MAY BE .  WARRENCHERYL  Excel Worksheet Functions  1  January 5th 05 08:15 AM 
calculate weeks from a start date ( not yr weeks)  Todd F.  Excel Worksheet Functions  6  November 27th 04 05:53 PM 