I don't see a straight date format that automatically translates a date into quarters. On the other hand, if you use PivotTables, then yes, there is a way to do that. Actually, sometimes the PivotTable will automagically generate quarters for you!
Group Dates in a Pivot Table
https://excelchamps.com/blog/group-dates-in-a-pivot-table/
A pivot table is full of awesome features. It doesn’t matter how big your data is, there is no problem for pivot table to handle it. Creating a group of dates in a pivot table is one those features. With this, you can instantly create insightful and
ready to present reports. When you work with a data where you have dates in it, the best thing to summarize it in months, years, or quarters.
. * Groups Dates in a Pivot Table by Month / Quarter / Year / Second / Minute / Hour / day
. * Groups of 7 Days to Create Weekly Summary
. * Hourly Summary if You Have Time with Dates
. * Creating a
Custom Date Range Summary
. * Grouping
Two Different Fields
. * Un-Grouping
ET MR PivotTables.docx.
This is the best date format article I've found, no option for quarters
Format Dates and Times
and Dates.
! Custom Date Formats in Excel
https://www.myexcelonline.com/blog/custom-date-formats-in-excel/
Custom date formats in Excel allow you to display only certain parts of the date.
Say you had a date of 18/02/1979, which coincides to be my birthday.
You can use the Format Cells dialogue box to show only the number 18, the day that corresponds to that date (Sunday), the month as a number on in abbreviated form and the year in two or four digits.
You cam also mix and match to create a custom date format or even enter a custom text that would show something like:
Today is Sunday
You can download the following workbook which shows you the different formats that you can use and see the tutorial below of how this can be easily achieved.
DOWNLOAD WORKBOOK
CODE
OUTPUT
DATE/TIME
APPEARS AS
m Displays the month as a number
18/02/1979 2
mm Displays the month as a number with leading zeros
18/02/1979 02
mmm Displays the month in abbreviated form
18/02/1979 Feb
mmmm Displays the month in full form
18/02/1979 February
mmmmm Displays the first letter of the month
18/02/1979 F
d Displays the day as a number
18/02/1979 18
dd Displays the day as a number with leading zeros
01/02/1979 01
ddd Displays the day in abbreviated form
18/02/1979 Thu
dddd Displays the day in full form
18/02/1979 Thursday
yy Displays the last two digits of the year
18/02/1979 79
yyyy Displays all the digits of the year
18/02/1979 1979
mmmm d, yyyy Displays the month, the date and the year
18/02/1979 February 18, 1979
mmmm-yyyy Displays the month-year
18/02/1979 February-1979
“Today is” dddd Displays a custom text for the Today function
11/06/2015 Today is Thursday
h Displays the hour as a number
9:05:13 9
hh Displays the hour as a number with leading zeros
9:05:13 09
m Displays minute as number
9:05:13 5
mm Displays minutes as a number
9:05:13 05
s Displays seconds as a number
9:05:03 3
ss Displays seconds as a number
9:05:13 03
ss.s Display tenth of second
9:05:13.3 13.3
ss.00 Displays hundredths of second
9:05:13.03 13.03
AM/PM Displays the hour indicating AM or PM
9:55:13 AM
https://www.myexcelonline.com/wp-content/uploads/2015/06/Number-Formats-Dates.gif
.
