| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quarter date format
No, because there isn't a standard definition for quarter.
-- Regards, Tom Ogilvy "Alberto Tejada" wrote in message ... I'm working with dates and I want to know which quarter the date belongs to. Is there a date format to see the quarter? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Quarter date format
for calandar year end use: =INT((MONTH(B2)-1)/3)+1 for fiscal year end: =MOD(CEILING(22+MONTH(B2)-9-1,3)/3,4)+1 assuming fiscal year end is Septemer = 9 in the formula, change th ending month number to fit your's need ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto format quarter start date | Excel Discussion (Misc queries) | |||
| Quarter End Date | Excel Worksheet Functions | |||
| Format to display date as Quarter | Excel Discussion (Misc queries) | |||
| Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
| Converting a date in Excel 2002 to a Year/Quarter format | Excel Worksheet Functions | |||
Linear Mode
