Consecutive dates in each excel worksheet?

J

JESSEKA

I wanted to know if it was possible to have consecutive dates automatically
appear on different sheets of my workbook. Like, you know how if you type in
a date in a cell and drag it, the consecutive dates will follow, but I don't
want to do this on one worksheet, I want it to happen on different sheets.
Like on sheet1, I want to have say, 6/17/2008 and on sheet2, I want the date
to be 6?18/2008, sheet3 to have 6/19/2008 and so on. I have like a workbook
of 80 sheets which are each 80 different days of data. Any formulas or help???
 
M

Marcelo

on sheet1 a1

06/17/2008

sheet2 a1
=sheet1!a1+1


sheet3 a1
=sheet2!a1+1

and so on.
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"JESSEKA" escreveu:
 
J

JESSEKA

Is there a way that this can be automatically done without having to put a
formula on each sheet? Because if i have to copy this formula into each
sheet, I might as well just add the date ya know???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top