Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
entering date functions
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
entering date functions
=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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
entering date functions
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
entering date functions
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
entering date functions
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
entering date functions
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? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
entering date functions
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? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date functions | New Users to Excel | |||
Date difference | Excel Worksheet Functions | |||
date and time | New Users to Excel | |||
Entering date QUICKLY | New Users to Excel | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |