Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto working week-ending date for timesheet | Excel Worksheet Functions | |||
Calculate Start Dates based on Need-By Date? | Excel Worksheet Functions | |||
Customized Date Format | Excel Worksheet Functions | |||
format date in excel | Excel Discussion (Misc queries) | |||
date format in excel not in line with control panel regional setti | Excel Discussion (Misc queries) |