View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sunnyskies Sunnyskies is offline
external usenet poster
 
Posts: 107
Default 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.