Creating a Worksheet with date

  • Thread starter Thread starter MD
  • Start date Start date
M

MD

Hi,

I'm trying to creat a wroksheet that will have two weeks
of date at the top row to be printed every two weeks and
each time printing, it shows the next two weeks
automatically. I'm very new on doing this, please help if
there is anyway of doing this.

Thank you in advance for your help.

Regards,

MD
 
Thanks Paul, It worked.

MD
-----Original Message-----
Md, how about putting the first date in A1 and then this formula in B1 and
copy accross to as many columns as needed, then you will only have to change
the date in A1, this could be changed automatically when you print if you
print on the same day, =A1+1
--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **



.
Click to expand...
 
Back
Top