For financial reports, you may find it useful to present information in terms of quarters. The following formula returns an integer between 1 and 4 that corresponds to the calendar quarter for the date in cell A1:

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

This formula divides the month number by 3 and then rounds up the result.

• Track Your Money with Excel Many people utilize the software program known as Excel to set up their budget as well as to manage it....
• Heart Attack Victim Recovers In Stem Cell Research Study As part of a new stem cell treatment series, I am trying to find patients who have been helped by...
• Saving for a Rainy Day Having a few easy and down to earth concepts and ideas for spending less, cutting expenses and socking money away...
• Palm Pre Sets The New High Bar for Smartphones I've been playing with the Palm Pre for about a full day now and it is an impressive phone. In...
• To smartphone or not to smartphone? My cell phone is on its last legs.  I have to insert the phone very carefully into the charger now,...