Auto format quarter start date

[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?

[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 have the Analysis Toolpak installed. To do so go to Tools,AddIns,check the Analysis ToolPak option and click ok. Others need to have the ToolPak installed to see this correctly as well.

HTH

Steve

[SteveG]

mabeymom,

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

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

HTH

Steve