Help writing a program to use in Excel?

Question

Hello! I haven't used excel in about 8 years other than to view someone else's work... so before I go and try to relearn how to write equations and programs in I figured I'd try asking the Y!A community real quick.

I need a program that I can enter a date and have the program add 60 calender days and place it in the next cell.

What would the line of code look like for that?

Thank you for your answers thus far.. but I suppose I should have been a little more specific. I need to make it so that someone else could just enter the current date and it would always print the date 60 days in advance in the next cell.

Again, thank you for your time.

And this is someone that doesn't want to just look at a calender... so they won't want to type in the program each time either... so how can I make it automatically do this?

NM, thank you guys.. I remembered you could click and drag cells to extend the program, thank you for your help

Yeah.. the drag and pull to expand the program will work I guess.. but the auto-fill of the cells is what I'm really looking for.

Answer 1

I know *exactly* what you're trying to do, and I've had occasion off and on for YEARS to try and make this happen.

I have never been able to make this happen. And you're right - the answers so far (first two) don't do what you want.

Sorry - but I'm starring this in the hopes of someone else nailing it.

Answer 2

in A1 enter the date: 11/12/07 example
then select Format / Cell / Date (and format that cell as a date)

in A2 enter: =A1+60
also format A2 as a date...just as above.

good luck
:)
feel free to contact me with any excel questions ♥

Answer 3

I just tried this. Put your date in A1, then in B1, put =A1+60. Make sure each cell is set to date format. (Select the cells, press CTRL+1 and select DATE Format.)

Looks like that does it.