Format Cells

D

dot

How do I format a cell in excel to show the quarter of the year(1st,2nd,etc)
when a date is in the cell (e.g. 7/25/2006.) I don't see this as an option
in the custom format section
 
M

Marcelo

hi dot,

in an auxiliar range do a table like this

A B C
1 1/1/2006 3/31/2006 1st Q
2 4/1/2006 6/30/2006 2nd Q
3 7/1/2006 9/30/2006 3rd Q
4 10/1/2006 12/31/2006 4th Q

assuming the data is on F4 use a formula like:
=text(f4,"mm/dd/aaaa")&" "&vlookup(f4,a1:c4,3)

hth
regards from Brazil
Marcelo


"dot" escreveu:
 
Top