Thread: Format a cell to give quarternumber from a date in Excell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Anthony D Anthony D is offline
external usenet poster
  
Posts: 78
Default 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 With QuoteReply With Quote