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?
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?
=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.
"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?
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
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?
Thank you that was easy enough
"Roger Govier" wrote:
> 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
>
>
> 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?
>
Thank you that was easy enough!
"bpeltzer" wrote:
> =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.
>
> "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?
Can I use the formula for an entire row? Or do I need to do each cell
individually>
"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?
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?
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks