Auto format quarter start date

M

mabeymom

I am trying to have excel auto populate the date of each quarter. So for
first quarter 2007- 1/1/2007 second 4/1/2007 etc. Right now I have the
start date +90 but some quarter is +91 or +92 etc. How can I always get it
to populate the 1st day?
 
S

SteveG

mabeymom,

In A1 enter the start date in A2 enter,

=EDATE(A1,3)

Drag down to get each succesive quarter start date. You need to hav
the Analysis Toolpak installed. To do so go to Tools,AddIns,check th
Analysis ToolPak option and click ok. Others need to have the ToolPa
installed to see this correctly as well.

HTH

Stev
 
S

SteveG

mabeymom,

If you don't want to bother with the ToolPak then,

=DATE(YEAR(A1),MONTH(A1)+3,DAY(A1))

HTH

Steve
 
Top