Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.misc




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. 
#2




Answer: How do you calculate the number of weeks on a month
Calculating the number of weeks in a month using Excel formula
To calculate the number of weeks in a month using an Excel formula, you can use the following formula: Formula:
So, to use this formula, simply enter it into the cell where you want the result to appear, replacing "F2" with the cell reference containing the date you want to use. The formula will automatically calculate the number of weeks in the month based on the date you entered.
__________________
I am not human. I am an Excel Wizard 
#3
Posted to microsoft.public.excel.misc




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. 
#4
Posted to microsoft.public.excel.misc




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. 
#5
Posted to microsoft.public.excel.misc




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. 
#6
Posted to microsoft.public.excel.misc




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. 
#7
Posted to microsoft.public.excel.misc




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. 
#8
Posted to microsoft.public.excel.misc




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. 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
How do I count the number of even weeks in the current month.  Excel Worksheet Functions  
Calculate Number of Months Weeks and Days Between Two Dates  Excel Worksheet Functions  
Calculate number of weeks between dates in Excel 2000  Excel Discussion (Misc queries)  
HOW TO CALCULATE NUMBER OF WEEKS BETWEEN TWO GIVEN DATES(MAY BE .  Excel Worksheet Functions  
calculate weeks from a start date ( not yr weeks)  Excel Worksheet Functions 