Excel Add Days

[Bertronix]

Hi,
I am using an A column to enter cureent dates, I would like the J column to automatically add 45 days to the date I enter in A column.Is this feasible? Thanks in advance!Bertronix.

[Anne Troy]

Sure.
In J2, put

=A2+45

Not too difficult, huh?
Make sure A2 and J2 are formatted as dates.

[Bertronix]

Hi Dreamboat,
Man that reply was so fast it scared me! O.K. I literally just started using Excel and this is my first formula (talk about newbie). How do I format A and J as dates? Thanks again,Bertronix.

[stone]

Select your cells, goto Format - Cells, select number, and then select dates.

BK stulli

[Bertronix]

Thanks, Really appreciate the help! Bertronix

[Bertronix]

Hi Stone,
Still can't get this to work! What I'm doing is as I go down column A, each cell will have a different date. I'm trying to get column J to automatically enter 45 days to whatever I type in column A. I tried what both you and Dreamboat responded with but it's not executing. What am I doing wrong? Sorry, I'm really new at this! Bertronix.

[sykes]

Bertronix
Right click in A1, select format cells,
pick from left hand column "date"
pick from right hand column 14-mar-98.
This will format the cell A1 for this kind of date. When you get the hang of it, you can change this to your hearts content.
Do the same for J1 (just to get started).
SelectA1.
Put a date in it.
select J1, type "=A1+45" (without the quotation marks) and hit the return key on your keyboard, or with the cursor, select the green tick just above the ABCD etc address bar.(next to the red cross). Make sure you do this without clicking out of J1.

This should change the J1 date to A1+45.

Come back in a min. for more.

Good luck, and DON'T GIVE UP !!
Kindest

Sykes

[Bertronix]

Thanks Sykes,
I'm starting over, first of all I was using about 4 rows to create a heading and I understand that this is a no-no. Once i get reset I'll try what you posted. Thanks a million for responding! Bertronix.

[Anne Troy]

Bert:

Putting a formula in one cell will not work with all cells.

Once you have entered that formula in J, select the cell you entered it into.
You'll see a small black square on the bottom, right-hand corner of the cell. This is called the Fill Handle. When you click on it, your cursor turns from a FAT Plus sign into a skinny plus sign. Click on the fill handle and drag down all the rows you need to.

If A does not have a date in that cell right now, and you get errors from the formula, change the formula I very first gave you to:

=if(isblank(A2),"",a2+45)

That means column J will show nothing ("") until there's a date typed into the same row in column A.

If you're really having difficulty, I'm here for the day pretty much, and you can email the file. Dreamboat@TheWordExpert.com

[Bertronix]

Hi,
O.K. I got it to work fine except that until I enter my date in the A column, the J column is filled with the date 02/14/00. When I enter a date in A it changes J correctly. I can live with that! You guys have been so helpful. Thanks, Bertronix.