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

Hi Gail

In B1
=$A$1+(Column()-1)*30
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
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)
Drag across as before.

Regards

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?