Formulating a DUE DATE

[Kidmon]

I am using excel 2007
I know this is simple for you Pros but...
All I need to do is enter a date value in column A and have Column B autofill and increase that date by a give period (i.e. 2 weeks)


Something like this
Check out Date: 2/2/2011 (Column A)
Due Date: 2/16/2011 (Column B) Autofill from Column A

Thanx for the help, you guys are awsome

 

[texasalynn]

if I understand you correctly then a math function is all you need
=A1+14

 

[jim may]

Paste into your Sheets Module

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 1 Then Exit Sub
Target.Offset(, 1).Value = Target + 14
End Sub

 

[Kidmon]

Almost but not quite. I didn't make it clear that column A with have different dates in each cell. You easy formula works great on B1=A1+14 BUT I meant to say that every cell in column A will contain a specific and Column B will be that date plus 14. Many dates & many cells in the 2 columns, just 14 day difference.
Thanx

 

[Kidmon]

Thanx Jim, HOWEVER< I don't really understand the way you are writing the formula, remember I am a newbee at excel. Do you have another way to help me understand? and to make sure I had made it clear I need every cell in ColumnB to increase by 14 in relation to the same ROW for ColumnA date.
Thanx for your interest.
Thanx for helping me move my mountain.

 

[jasonb75]

Almost but not quite. I didn't make it clear that column A with have different dates in each cell. You easy formula works great on B1=A1+14 BUT I meant to say that every cell in column A will contain a specific and Column B will be that date plus 14. Many dates & many cells in the 2 columns, just 14 day difference.
Thanx

Enter the formula in B1, then move your mouse to the bottom right corner of B1 so that the cursor changes from white to black, then double click.

 

[jim may]

Kidmon,

My solution is NOT formula-based.

It is an Event-Macro.

Jim