Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default I need worksheet with a mnth worth of dts. 1 date a sheet.. HOW?

I need to make a worksheet with a month worth of dates on it... One day for
each tab...is there any easy way to do this???
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default I need worksheet with a mnth worth of dts. 1 date a sheet.. HOW?

The way i would do it is to create a list of dates you want to have as tabs
in a list labled date.

Then do a pivot table on that list

then put the date in the page of the pivot table

Then Click on the pivot table show pages command on the pivot table toolbar.

Then select all pages and delete the pivot tables.

Some one more expert may have an eiser way but I do this all the time.

Brian Bleifeld

"LDvorak" wrote:

I need to make a worksheet with a month worth of dates on it... One day for
each tab...is there any easy way to do this???

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How do I create a schedule from a list of dates ? Gavin Morris Charts and Charting in Excel 2 October 28th 10 04:08 PM
Date formulas DRondeau Excel Discussion (Misc queries) 7 September 6th 06 09:53 PM
How do I copy a date in a worksheet cell to another worksheet? JennLee Excel Worksheet Functions 3 February 17th 06 05:38 PM
make an excel worksheet (sheet 2) open w/ the cursor located in t. animated text in excel worksheet Excel Discussion (Misc queries) 0 February 10th 05 10:29 PM
Date updates from worksheet to chart & changes date to a date series! Help!! Jayjg Charts and Charting in Excel 2 January 22nd 05 03:00 PM


All times are GMT +1. The time now is 05:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"