Date conversion
 

Help! I am trying to convert a birthday to 15days out 2005.
For example, I have a birthday 7/15//1942 and I want to make it so that it
converts it to 7/30/2005.

How should I set up the excep spreadsheet for this kind of computation?
I am lack technical computer verbage, so please spell it out for me.

Thanks much,
Stephanie Myers

Stephanie

if the date is in cell A1, try:

=DATE(2005,MONTH(A1),DAY(A1)+15)

but note that dates late in December could generate dates in 2006

Regards

Trevor


"Stephanie Myers" wrote in
message ...
Help! I am trying to convert a birthday to 15days out 2005.
For example, I have a birthday 7/15//1942 and I want to make it so that it
converts it to 7/30/2005.

How should I set up the excep spreadsheet for this kind of computation?
I am lack technical computer verbage, so please spell it out for me.

Thanks much,
Stephanie Myers

How do I apply this formula to a spreadsheet column that displays 400+
different birthdays with varying months & days?

=DATE(2005,MONTH(A1),DAY(A1)+15)

Or will I need to use a modified formula?

Thanks much!
Stephanie

Stephanie

you could use autofill. Assume your data is in column A, as in the example.
Put the formula in cell B1, or the next free column on your sheet. Move the
cursor to the bottom right corner of the cell until it turns into a
cross-hair and double click. If there are no gaps in your data, the formula
should fill down to the bottom and adjust as it goes.

So cell B1 would be: =DATE(2005,MONTH(A1),DAY(A1)+15)
B2 would be: =DATE(2005,MONTH(A2),DAY(A2)+15)

and so on

Regards

Trevor


"Stephanie Myers" wrote in
message ...
How do I apply this formula to a spreadsheet column that displays 400+
different birthdays with varying months & days?

=DATE(2005,MONTH(A1),DAY(A1)+15)

Or will I need to use a modified formula?

Thanks much!
Stephanie

Trevor,

It worked -- Thank you very much!
Have a great day.

You're very welcome. Thanks for the feedback.


"Stephanie Myers" wrote in
message ...

Trevor,

It worked -- Thank you very much!
Have a great day.