Excel in XL
An educational blog for excellence in Microsoft Excel
Sunday, February 26, 2017
Find a Quarter Number from Given Date
A custom formula using two functions and return quarter number from given date, based on calendar year.
=ROUNDUP(MONTH(A1)/3,0)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment