Patrick Simonds

Posts: n/a

A tough problem

I have a workbook with 4 Worksheets

June - August
September - November
December - February
March - May

Across the top of each worksheet I need the date of the 2nd and 4th Tuesday
of each month (June - August, September - November ect). Now I know I can
just sit down and enter this manually, but I want this to automatically
update depending on the year which I have entered in cell A1. I am at a loss
for how to do this, so any of you miracle workers out there have any ideas?

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
Excel Display Problem	Bill Martin -- (Remove NOSPAM from address)	Excel Discussion (Misc queries)	0	April 19th 05 05:25 PM
Tough problem with rotas	Scott Cheesman	Excel Discussion (Misc queries)	0	April 2nd 05 10:51 AM
EXCEL 2003 PROBLEM	Amandle	Excel Worksheet Functions	4	April 1st 05 02:25 PM
Freeze Pane problem in shared workbooks	JM	Excel Discussion (Misc queries)	1	February 1st 05 12:04 AM
Row Autofit problem Excel 2003	Matthias Klaey	Excel Discussion (Misc queries)	0	January 19th 05 05:33 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us