| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I NEED A FORMULA THAT TAKES THE DATE AND CONVERT IT IN A QUARTER
I DEVELOP A MODEL, I NEED TO TAKE A DATE AND CONVERT IT IN QUARTER
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I NEED A FORMULA THAT TAKES THE DATE AND CONVERT IT IN A QUARTER
With
A1: (a date) This formula returns the quarter number (1,2,3, or 4): =CEILING(MONTH(A1)/3,1) Also: Please don't type in all capital letters...it's painful to read. (It also means you're yelling) Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "jcm" wrote in message ... I DEVELOP A MODEL, I NEED TO TAKE A DATE AND CONVERT IT IN QUARTER |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| How do I convert a specific date to a fiscal quarter ? | Excel Discussion (Misc queries) | |||
| Excel should have a QUARTER formula for DATE calculations | Excel Worksheet Functions | |||
| Quarter End Date | Excel Worksheet Functions | |||
| Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
Linear Mode
