| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format a cell to give quarternumber from a date in Excell
Hi,
How do I format a cell in Excell to give me the quarternumber from a date? Example: 2006-09-20 give quarternumber 3 -- nets |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format a cell to give quarternumber from a date in Excell
Hi,
There isn't a standard format but quarter number can be derived e.g. with date in a1, quarter number in b1 =ROUNDUP(MONTH(a1)/3,0) Anthony "Nets" wrote: Hi, How do I format a cell in Excell to give me the quarternumber from a date? Example: 2006-09-20 give quarternumber 3 -- nets |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excell 2003 Cell format issue | Excel Discussion (Misc queries) | |||
| How do I format a cell to blink in Excell? | Excel Discussion (Misc queries) | |||
| How do I change the date format in Excell from eg 20060926 | Excel Discussion (Misc queries) | |||
| How to give the numberformat the systemdefault date format? | Excel Programming | |||
| How can I format an cell in excell:10min50Sec 88hundreths of a Sec | Excel Discussion (Misc queries) | |||
Linear Mode
