entering date functions

G

Gail

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

bpeltzer

=a1+30 will return a date 30 days after the date in a1. It may not look like
a date at first; if not, then just Format > Cells, select the Number tab,
the Date category and choose the format you want. Dates (and times) in Excel
are just specially formatted numbers. Days are the integer part, times are
the fraction.
 
R

Roger Govier

Hi Gail

With your start Date in A1, format cells B1 and C1 with the same Date format.
In B1 =A1+30
In C1 =A1+60

Regards

Roger Govier
 
G

Gail

Thank you that was easy enough

Roger Govier said:
Hi Gail

With your start Date in A1, format cells B1 and C1 with the same Date format.
In B1 =A1+30
In C1 =A1+60

Regards

Roger Govier
Click to expand...
 
G

Gail

Thank you that was easy enough!

bpeltzer said:
=a1+30 will return a date 30 days after the date in a1. It may not look like
a date at first; if not, then just Format > Cells, select the Number tab,
the Date category and choose the format you want. Dates (and times) in Excel
are just specially formatted numbers. Days are the integer part, times are
the fraction.
Click to expand...
 
R

Roger Govier

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
 
Top