Skip to content

John Dalesandro

Technology to get things done

  • Home
  • Laboratory
    • WordPress Spam Blocker Plugin
    • WordPress Contact Form Plugin
  • Site Info
    • About John Dalesandro
    • Contact
    • Privacy Statement

Excel

Calculate Quarter Number In Excel

October 30th, 2015February 17th, 2009 by John Dalesandro

To calculate the quarter number for a given date (A1) in a regular calendar year, enter the following formula:

1
=ROUNDUP(MONTH(A1)/3,0)

Categories Computing Tags Excel, Source Code Leave a comment
Post navigation
Newer posts
← Previous 1 … 3 4
Copyright © 2019 John Dalesandro. All Rights Reserved.
Scroll back to top