View Single Post
  #8   Report Post  
Old November 22nd 05, 08:24 PM posted to microsoft.public.excel.worksheet.functions
Roger Govier
Posts: n/a
Default entering date functions

Hi Gail

In B1
Drag across through C1:Z1 or as far as you wish.

Do you really want to keep incrementing by 30 days, or were you trying to
find a way of increasing each month?
If the latter, then in B1
Drag across as before.


Roger Govier

Gail wrote:
Can I use the formula in an entire row or do I have to do each one seperately

"Gail" wrote:

I would like to set up my worksheet so that I can enter a date in one cell
and make the next cell automatically be dated for 30 days later and the next
for 60 and so on. Is there a function I can program to set this up? If so
what is it?