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

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