Lean Spreadsheets
Excel tips, tricks and effective ways to use professional spreadsheets
Pages
Home
Formula
Finance
Treasury
Business analysis
Visualise data
Power Pivot
Resources
Tuesday, 27 March 2012
Calculate calendar quarter from a date - Excel
Type
=INT((MONTH(A1)-1)/3)+1
Where cell A1 contains the date
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment