Auto format quarter start date
 

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?

Auto format quarter start date
 

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
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=561574

Auto format quarter start date
 

mabeymom,

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

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

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=561574