Skip to content
  • Home
  • About
  • All posts
  • Contact
  • Ask a question
  • Home
  • About
  • All posts
  • Contact
  • Ask a question
Login to online classes
  • Start Here
  • Blog
  • Classes
    • Excel School
    • VBA Classes – Learn VBA Macros today
    • Power BI Play Date
    • 50 Ways to Analyze your Data
    • Mini-Courses
    • Power BI Remote Training Options
  • Videos
    • Intro to Excel
    • Writing Formulas
    • … more
  • Topics
    • Excel Basics
    • Advanced Excel Skills
    • Learn Power BI
    • Power Query Tutorial
    • Excel Pivot Tables – Full guide
    • Project Management using Excel
  • Formulas
    • Tables & Structural Refs
    • IF
    • CHOOSE
    • XLOOKUP
    • SUMIFS
    • SUBTOTAL
    • INDEX
    • VLOOKUP & other lookups
    • 100+ Formula Examples
    • Multi-condition lookups
    • Array formulas
    • Top 10 formulas
  • Dashboards
    • What are they, how to make one?
    • Dynamic Dashboard in Excel
    • Customer Service Dashboard
    • 200+ Examples
    • Dashboard Training Course
  • Charts
  • VBA
    • 40+ Examples
    • More on VBA
  • Resources
    • 100s of FREE Excel Templates
    • Resources for Freelancers
    • Mini-Courses
  • Start Here
  • Blog
  • Classes
    • Excel School
    • VBA Classes – Learn VBA Macros today
    • Power BI Play Date
    • 50 Ways to Analyze your Data
    • Mini-Courses
    • Power BI Remote Training Options
  • Videos
    • Intro to Excel
    • Writing Formulas
    • … more
  • Topics
    • Excel Basics
    • Advanced Excel Skills
    • Learn Power BI
    • Power Query Tutorial
    • Excel Pivot Tables – Full guide
    • Project Management using Excel
  • Formulas
    • Tables & Structural Refs
    • IF
    • CHOOSE
    • XLOOKUP
    • SUMIFS
    • SUBTOTAL
    • INDEX
    • VLOOKUP & other lookups
    • 100+ Formula Examples
    • Multi-condition lookups
    • Array formulas
    • Top 10 formulas
  • Dashboards
    • What are they, how to make one?
    • Dynamic Dashboard in Excel
    • Customer Service Dashboard
    • 200+ Examples
    • Dashboard Training Course
  • Charts
  • VBA
    • 40+ Examples
    • More on VBA
  • Resources
    • 100s of FREE Excel Templates
    • Resources for Freelancers
    • Mini-Courses

Tag: weeknum

How to calculate WEEKNUMBER in Month / Quarter / Year with Excel?

Weeknumber in a month / quarter / year with excel formulas

Let’s say you have daily data and your boss wants to see the trends by week in month or week in quarter? How do you calculate the week number in a month or quarter? In this article, let me explain the logic and formulas we can use Excel for this.

Get FREE Excel & Power-BI Newsletter

One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free. 

Yes, sign me up

Get Started

  • Excel Basics
  • Advanced Excel
  • 100+ Formulas
  • Free Crash Course
  • Pivot Tables
  • Power BI

Online Classes

  • Excel School
  • VBA Classes
  • Power BI Classes
  • 50 ways to analyze data
  • Mini Courses

About

  • My Story
  • Welcome Message
  • Contact
  • Forum & Community

Downloads

  • 20+ Excel Templates
  • 200+ Dashboards
  • 40+ VBA Code samples
  • Ebooks & More
Twitter Facebook-f Youtube Linkedin-in

© All rights reserved.