Auto format quarter start date

[Guest]

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

 

[SteveG]

mabeymom,

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

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

HTH

Steve