Posted to microsoft.public.excel.misc

mabeymom

external usenet poster

Posts: 1

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
auto working week-ending date for timesheet	Dm76	Excel Worksheet Functions	4	March 27th 06 10:21 PM
Calculate Start Dates based on Need-By Date?	GB	Excel Worksheet Functions	2	February 21st 06 06:11 PM
Customized Date Format	Frustrated	Excel Worksheet Functions	5	October 7th 05 11:30 PM
format date in excel	Nigel	Excel Discussion (Misc queries)	2	September 15th 05 09:52 PM
date format in excel not in line with control panel regional setti	GrahamR	Excel Discussion (Misc queries)	3	August 2nd 05 06:48 PM

All times are GMT +1. The time now is 02:49 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us