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