Working with Quarters in Excel

You might not know that Excel knows about quarters. That’s 3 months, not 25 cents.

If you type Q1 in a call and drag the cell with the Fill Handle (bottom right corner of cell) you will see that Excel repeats the sequence Q1, Q2, Q3 and Q4. It doesn’t do Q5 or above.

This works for Qtr1 as well.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.