I need worksheet with a mnth worth of dts. 1 date a sheet.. HOW?

L

LDvorak

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???
 
E

Engineering Accountant

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
 
Top